Skip Headers

Oracle® Enterprise Manager Extensibility 10g Release 2 (10.2) for Windows or UNIX Part Number B16246-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# 6 Management Repository Views

Enterprise Manager repository views are used to access information in the Management Repository for further processing and/or presentation.

Important: Views supplied with Enterprise Manager 10g release 10.2 are provisional. Provisional views, although fully supported for the current release of Enterprise Manager 10g, may change in subsequent releases. Backward compatibility is not guaranteed for provisional views.

This chapter covers the following:

- Overview

- Monitoring Views

- Inventory Views

- Policy Definition Views

- Policy Association Views

- Policy Violation Views

- Management Template Views

- Job Views

- Application Service Level Management Views

- Configuration Views

- Oracle Home Patching Views

- Linux Patching Views

- Security Views

- Configuration Management Views

- Database Cluster Views

- Storage Reporting Views

## Overview

The Enterprise Manager Management Repository views provide access to target, metric, and monitoring information stored in the Management Repository. Accessing the repository will allow you to perform the following:

- Obtain pertinent application-specific information at the right level of granularity and density for a wider variety of users: IT staff, executives, developers.

- Send alerts for metric threshold violations.

- Perform historical analysis or additional computation on stored data.

- Seamless integration of Enterprise Manager alerts with user ticketing systems, such as iSupport and Remedy.

The Management Repository is the comprehensive source for all the management information for Enterprise Manager, with the key to extensibility being the repository's open schema. This open architecture allows users to customize how the information in the repository is used if Enterprise Manager's standard configuration does not meet their requirements. To facilitate easy access to information stored in the repository, Enterprise Manager supplies a comprehensive set of views rather than forcing the user to access repository base tables directly. Views buffer custom applications from any underlying changes to the repository schema and ensures up-stream applications will not break when the repository schema changes via patching or new releases.

Using Repository Views

Because the views are simple queries to a database, users can imbed these queries within any application code used to return information for further processing and/or display in the Enterprise Manager Grid Control console.

As shown in Example 6-1, "View Usage", the Java code uses Enterprise Manager views to query the Management Repository rather than accessing the repository tables directly. For each of four time windows, there are four SQL statements with questions marks ('?') as placeholders for the parameters.

Example 6-1 View Usage

    public static final String hour_stmt =

    "SELECT collection_timestamp, value "+
    "FROM mgmt$metric_details " +
    "WHERE target_type = ? and target_name = ? and metric_name = ? and metric_column= ? " +
    "and collection_timestamp > sysdate - 1/24 " +
    "ORDER BY collection_timestamp ";

    public static final String day_stmt =

    "SELECT rollup_timestamp, average "+
    "FROM mgmt$metric_hourly " +
    "WHERE target_type = ? and target_name = ? and metric_name = ? and metric_column= ? " +

    "and rollup_timestamp > sysdate - 1 " +
         "ORDER BY rollup_timestamp";

    public static final String week_stmt =

    "SELECT rollup_timestamp, average "+
    "FROM mgmt$metric_daily " +
    "WHERE target_type = ? and target_name = ? and metric_name = ? and metric_column= ? " +
    "and rollup_timestamp > sysdate - 7 " +
    "ORDER BY rollup_timestamp";

    public static final String month_stmt =

    "SELECT rollup_timestamp, average "+
    "FROM mgmt$metric_daily " +
    "WHERE target_type = ? and target_name = ? and metric_name = ? and metric_column= ? " +
    "and rollup_timestamp > sysdate - 31 " +
    "ORDER BY rollup_timestamp";

## Monitoring Views

### MGMT$METRIC_ERROR_HISTORY

MGMT$METRIC_ERROR_HISTORY displays the history of metric collection errors that have occurred in last 3 months.

Table 6-1 MGMT$METRIC_ERROR_HISTORY

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(256) | The name of the target for which the metric collection error occurred.
TARGET_TYPE | VARCHAR2(64) | Target type defines the set of metrics that are applicable for the target.
TARGET_GUID | RAW(16) | Target GUID of the target for which the metric collection error occurred.
METRIC_NAME | VARCHAR2(64) | Name of the metric for which the error occurred.
METRIC_LABEL | VARCHAR2(64) | User display name of the metric for which the error occurred.
COLL_NAME | VARCHAR2(256) | Name of the collection collecting the metric for which the error occurred.
COLLECTION_TIMESTAMP | DATE | Time when the collection error occurred.
ERROR_TYPE | NUMBER | Type of metric error. 0=Error 1=Warning
ERROR_MESSAGE | VARCHAR2(4000) | Text of the error message.

Usage Notes

List the history of metric errors for a given target.

List the history of metric errors for a given target and metric.

Queries using this view would use index if target_name and target_type were specified.

### MGMT$METRIC_ERROR_CURRENT

MGMT$METRIC_ERROR_CURRENT displays the metric collections that are currently generating errors.

Table 6-2 MGMT$METRIC_ERROR_CURRENT

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(256) | Name of the target for which the metric collection error occurred.
TARGET_TYPE | VARCHAR2(64) | Target type defines the set of metrics that are applicable for the target.
TARGET_GUID | RAW(16) | GUID of the target for which the metric collection error occurred.
METRIC_NAME | VARCHAR2(64) | Name of the metric for which the error occurred
METRIC_LABEL | VARCHAR2(64) | User display name of the metric for which the error occurred.
COLL_NAME | VARCHAR2(256) | Name of the collection collecting the metric for which the error occurred
COLLECTION_TIMESTAMP | DATE | Time when the collection error occurred.
ERROR_TYPE | NUMBER | Type of metric error. 0=Error 1=Warning
ERROR_MESSAGE | VARCHAR2(4000) | Text of the error message.

Usage Notes

List the current metric errors for a given target.

List the current metric errors for a given target and metric.

Queries using this view would use index if target_name and target_type were specified.

### MGMT$TARGET_COMPONENTS

MGMT$TARGET_COMPONENTS displays information about the software components that are associated with a managed target as well as details about where the software components have been installed.

Table 6-3 MGMT$TARGET_COMPONENTS

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(256) | Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator.
TARGET_TYPE | VARCHAR2(64) | Target type defines the set of metrics that are applicable for the target.
TARGET_GUID | RAW(16) | The unique global identifier (GUID) for the target.
HOST_NAME | VARCHAR2(64) | The name of the host where the software homes are located.
HOME_NAME | VARCHAR2(64) | The name for the location where the software is installed. This might be a user-supplied name or a name supplied by the Oracle Universal Installer.
HOME_TYPE | VARCHAR2(64) | Three categories of homes are available: · ORACLE_HOME · APPL_TOP · INDEPENDENT · UNKNOWN
HOME_LOCATION | VARCHAR2(128) | The file system path to the root of the home.
COMPONENT_NAME | VARCHAR2(128) | The name of the software component.
COMPONENT_ EXTERNAL_NAME | VARCHAR2(128) | The external name of the target, as specified during installation.
COMPONENT_VERSION | VARCHAR2(64) | The current version of the software component. If the software component has been patched, this version number may be different than the base version number.
COMPONENT_BASE_ VERSION | VARCHAR2(64) | Base version of the software component.
SNAPSHOT_GUID | RAW(16) | GUID of the snapshot.

Usage Notes

This view can be used to identify the software components that are part of a specific managed target.

Access to this view will use an index if the query references the target name and target type, the home location, or the host name.

### MGMT$BLACKOUT_HISTORY

MGMT$BLACKOUT_HISTORY displays a historical log of changes in the blackout state for a managed target. In addition, the view can be used to generate a list of targets that were in a blackout period for a specific period of time.

Table 6-4 MGMT$BLACKOUT_HISTORY

Column | Datatype | Description
--- | --- | ---
BLACKOUT_NAME | VARCHAR(64) | The name of the blackout.
CREATED_BY | VARCHAR(256) | The Enterprise Manager administrator who created the blackout.
BLACKOUT_GUID | RAW(16) | The unique global identifier (GUID) for the blackout.
START_TIME | DATE | Start of the blackout period for the managed target.
END_TIME | DATE | End of the blackout period for the managed target. If the target is currently in a blackout period, the END_ TIMESTAMP date will be NULL.
TARGET_NAME | VARCHAR2(64) | Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator.
TARGET_TYPE | VARCHAR2(64) | Types of targets may include databases, hosts, web servers, applications, or Application Servers. The definer of the collection definition at the Management Agent defines the target type. The target type defines the set of metrics that are collected for a managed target within the Management Repository.
STATUS | NUMBER(2) | Current status of the blackout. Status Values: 0: Scheduled 1: Start Processing 2: Start Partial 4: Started 5: Stop Pending 6: Stop Failed 7: Stop Partial 8: Edit Failed 9: Edit Partial 10: Stopped 11: Ended 12: Partial Blackout 13: Modify Pending

Usage Notes

Queries using this view will use an index if they reference the target_name, target_ type, start_timestamp, or end_timestamp.

Typically, blackout history information retrieved using this view will be ordered by target_name, target_type, and start_timestamp.

### MGMT$BLACKOUTS

MGMT$BLACKOUTS displays all blackout definition information along with current schedules.

Table 6-5 MGMT$BLACKOUTS

Column | Datatype | Description
--- | --- | ---
BLACKOUT_NAME | VARCHAR(64) | The name of the blackout.
BLACKOUT_GUID | RAW(16) | The unique global identifier (GUID) of the blackout.
REASON | VARCHAR(64) | Purpose of the blackout. Reasons are chosen from a predefined list by the report owner.
DESCRIPTION | VARCHAR2(2000) | Detailed information about the blackout.
STATUS | NUMBER(2) | Current status of the blackout. Status Values: 0: Scheduled 1: Start Processing 2: Start Partial 4: Started 5: Stop Pending 6: Stop Failed 7: Stop Partial 8: Edit Failed 9: Edit Partial 10: Stopped 11: Ended 12: Partial Blackout 13: Modify Pending
CREATED_BY | VARCHAR(256) | Administrator who created the blackout. CREATED_BY returns SYSTEM as the blackout owner if the blackout was created using the Enterprise Manager Command Line Interface.
LAST_START_TIME | DATE | Last time the blackout successfully started.
LAST_END_TIME | DATE | Last time the blackout successfully ended.
SCHEDULED_TIME | NUMBER | Possible values are: 0 - Immediate schedule 1 - Run once at specified time 2 - Run on interval 3 - Run daily 4 - Run on specified days of the week 5 - Run on specified days of the month 6 - Run on specified days of the year
SCHEDULE_START_TIME | DATE | Time the blackout is scheduled to start.
SCHEDULE_END_TIME | DATE | Time the blackout is scheduled to end.
DURATION | NUMBER | Duration of the blackout in minutes.

### MGMT$ALERT_ANNOTATIONS

MGMT$ALERT_ANNOTATIONS displays a summary of alert annotations.

Table 6-6 MGMT$

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(256) | Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator
TARGET_TYPE | VARCHAR2(64) | Target type defines the set of metrics that are applicable for the target.
TARGET_GUID | RAW(16) | The unique global identifier (GUID) for the target.
METRIC_NAME | VARCHAR2(64) | Name of the metric.
METRIC_COLUMN | VARCHAR2(64) | If the metric defined at collection time is a TABLE type, the name of the column in the table that is represented by this metric is written to this field. The metric column is part of the primary key that uniquely identifies the value of this table that this metric represents.
METRIC_LABEL | VARCHAR2(64) | Display name for the metric.
COLUMN_LABEL | VARCHAR2(64) | Display name for the column of a TABLE metric.
KEY_VALUE | VARCHAR2(256) | Key value of the alert violation. For composite keys, this is the first part of the key.
KEY_VALUE2 | VARCHAR2(256) | For comrposite keys, this is the second part of the key.
KEY_VALUE3 | VARCHAR2(256) | For composite keys, this is the third part of the key.
KEY_VALUE4 | VARCHAR2(256) | For composite keys, this is the fourth part of the key.
KEY_VALUE5 | VARCHAR2(256) | For composite keys, this is the fourth part of the key.
MESSAGE | VARCHAR2(4000) | The metric severity message.
ALERT_STATE | VARCHAR2(20) | A user readable description of the internal alert code that is sent from the Management Agent to identify the state of the alert condition. An alert record is transferred to the repository from the Management Agent each time the metric threshold is crossed in either direction, or if the Management Agent is restarted. The value of this column will contain one of the following strings: · Clear · Warning · Critical
COLLECTION_ TIMESTAMP | DATE | Date and time when the alert condition was detected by the Management Agent.
ANNOTATION_MESSAGE | VARCHAR2(4000) | Annotation text.
ANNOTATION_TIMESTAMP | DATE | Time the annotation was created.
ANNOTATED_BY | VARCHAR2(64) | Enterprise Manager administrator who authored the the annotation.
SOURCE_OBJ_GUID | RAW(16) | Unique global identifier (GUID) of the metric severity associated with this annotation.

### MGMT$ALERT_NOTIF_LOG

MGMT$ALERT_NOTIF_LOG displays a summary of alert notifications.

Table 6-7 MGMT$MGMT$ALERT_NOTIF_LOG

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(256) | Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator.
TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics that are applicable for the target.
TARGET_GUID | RAW(16) | The unique global identifier (GUID) for the target.
METRIC_NAME | VARCHAR2(64) | The name of the metric being defined.
METRIC_COLUMN | VARCHAR2(64) | For table metrics, the metric column contains the name of the column in the table that is being defined. If the metric that is being defined is not a table metric, the value in this column is a single space.For example, if the table describing the MGMT$TARGET_TYPE view was being defined as a table metric, Column Name, Data Type, and Description would be metric columns.
METRIC_LABEL | VARCHAR2(64) | A intuitive display name for the metric that is being defined.
COLUMN_LABEL | VARCHAR2(64) | For table metrics, the column label contains a user understandable display name for the metric column.
KEY_VALUE | VARCHAR2(256) | For table metrics, this column contains the value of the key column for the row in the table whose thresholds are being defined. If the thresholds are not for a table metric, or the thresholds apply for all rows in the metric column, then the value in this column will contain a single space.
KEY_VALUE2 | VARCHAR2(256) | For composite keys, this is the second part of the key.
KEY_VALUE3 | VARCHAR2(256) | For composite keys, this is the third part of the key.
KEY_VALUE4 | VARCHAR2(256) | For composite keys, this is the fourth part of the key.
KEY_VALUE5 | VARCHAR2(256) | For composite keys, this is the fifth part of the key.
MESSAGE | VARCHAR2(4000) | An optional message that is generated when the alert is created that provides additional information about the alert condition.
ALERT_STATE | VARCHAR2(20) | A user readable description of the internal alert code that is sent from the Management Agent to identify the state of the alert condition. A alert record is transferred to the repository from the Management Agent each time the metric threshold is crossed in either direction, or if the Management Agent is restarted. The value of this column will contain one of the following strings: · Clear · Warning · Critical
COLLECTION_ TIMESTAMP | DATE | Date and time when the alert condition was detected by the Management Agent.
DELIVERY_MESSAGE | VARCHAR2(1024) | Message indicating the success or failure of the notification delivery.
DELIVERY_TIMESTAMP | DATE | Time at which the log message was created.
SOURCE_OBJ_GUID | RAW(16) | Unique global identifer (GUID) of the metric severity associated with this delivery message.

### MGMT$TARGET_METRIC_COLLECTIONS

MGMT$TARGET_METRIC_COLLECTIONS displays information about the metric collections.

Table 6-8 MGMT$TARGET_METRIC_COLLECTIONS

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(64) | Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator.
TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics that are applicable for the target.
TARGET_GUID | RAW(16) | Unique global identifier (GUID) for the target.
METRIC_NAME | VARCHAR2(64) | Name of the metric being defined.
METRIC_COLUMN | VARCHAR2(64) | For table metrics, the metric column contains the name of the column in the table that is being defined. If the metric that is being defined is not a table metric, the value in this column is a single space.For example, if the table describing the MGMT$TARGET_TYPE view was being defined as a table metric, Column Name, Data Type, and Description would be metric columns.
METRIC_GUID | RAW(16) | Unique global identifier (GUID) for the metric. This ID can be used to associate metric information with metric data information during reporting.
COLLECTION_NAME | VARCHAR2(64) | The name of the collection.
IS_ENABLED | NUMBER(1) | Indicates whether the collection is currently enabled. 0=not enabled 1=enabled.
IS_REPOSITORY | NUMBER(1) | Indicates whether this is a repository-side collection. A repository-side collection has a PL/SQL evaluation procedure that is responsible for calculating the metric values.
FREQUENCY_CODE | NUMBER | The metric collection frequency type. Possible values are: 1: One Time 2: Interval 3: Daily 4: Weekly 5: Monthly 6: Yearly 7: On Demand
COLLECTION_FREQUENCY | VARCHAR2 | Frequency of the metric collection. Value displayed is dependent on the frequency code: ² For One Time, the start date-time is stored in DD-MON-YY HH24:MI format. ² For Interval type, the frequency in minutes is stored. ² For Daily/Weekly/Monthly/Yearly types, the hour and minute of collection is stored in HH24:MI format. ² For On-Demand type, On-Demand is stored.
UPLOAD_POLICY | NUMBER | The frequency with which the metric data is uploaded/stored.

Usage Notes

List the metric collections for a given target.

### MGMT$TARGET_METRIC_SETTINGS

MGMT$TARGET_METRIC_SETTINGS displays information about the current metric setting stored for all targets in the Management Repository. This view provides information for both agent-side and repository-side metrics.

Table 6-9 MGMT$TARGET_METRIC_SETTINGS

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(64) | Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator.
TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics that are applicable for the target.
TARGET_GUID | RAW(16) | The unique global identifier (GUID) for the target.
METRIC_NAME | VARCHAR2(64) | Name of the metric being defined.
METRIC_COLUMN | VARCHAR2(64) | For table metrics, the metric column contains the name of the column in the table that is being defined. If the metric that is being defined is not a table metric, the value in this column is a single space.For example, if the table describing the MGMT$TARGET_TYPE view was being defined as a table metric, Column Name, Data Type, and Description would be metric columns.
METRIC_GUID | RAW(16) | The unique global identifier for the metric. This ID can be used to associate metric information with metric data information during reporting.
COLLECTION_NAME | VARCHAR2(64) | The name of the collection.
CATEGORY | VARCHAR2(64) | The name of the category the metric.Refer to MGMT$METRIC_CATEGORIES for the list of all metric categories.
KEY_VALUE | VARCHAR2(256) | The key value of the metric setting. For composite keys, this is the first part of the key.If the thresholds are not for a table metric, or the thresholds apply for all rows in the metric column, then the value in this column will contain a single space.
KEY_VALUE2 | VARCHAR2(256) | For composite keys, this is the second part of the key.
KEY_VALUE3 | VARCHAR2(256) | For composite keys, this is the third part of the key.
KEY_VALUE4 | VARCHAR2(256) | For composite keys, this is the fourth part of the key.
KEY_VALUE5 | VARCHAR2(256) | For composite keys, this is the fifth part of the key.
KEY_OPERATOR | NUMBER | Specifies whether the key_value columns have any SQL wildcards.For single key column metrics, the value is 1 if the key_value has wildcard characters, 0 otherwise.For metrics with multiple keys, a list of operators for all key columns will be stored here. For example, a metric with 3 keys (k1, k2, k3) where K1 and K2 use wildcards and K3 uses exact match, then 011 is stored in this column.
HAS_ACTIVE_BASELINE | NUMBER(1) | The is a flag that specifies that the metric rows with this key_value has an active baseline and any user updates to thresholds/parameter values should be ignored.
PREVENT_OVERRIDE | NUMBER(1) | The is a flag that specifies that the metric rows with this key_value has a tempalte override flag. Once the tempalte override flag is ON, any template application will not update the threshold/parameter values.
WARNING_OPERATOR | NUMBER | Defines the warning threshold condition to be applied 0 - GT 1 - EQ 2 - LT 3 - LE 4 - GE 5 - CONTAINS 6 - NE 7 - MATCH : regular expression
WARNING_THRESHOLD | VARCHAR2(256) | The warning threshold value.
CRITICAL_OPERATOR | NUMBER | Defines the critical threshold condition to be applied. 0 - GT 1 - EQ 2 - LT 3 - LE 4 - GE 5 - CONTAINS 6 - NE 7 - MATCH : regular expression
CRITICAL_THRESHOLD | VARCHAR2(256) | The critical threshold value.
OCCURRENCE_COUNT | NUMBER | The number of times the test has to trigger to raise a violation.
WARNING_ACTION_TYPE | VARCHAR2(32) | Specifies the job type of the warning corrective action when WARNING_ACTION_TYPE is ÒCorrective-ActionÓ.
WARNING_ACTION_JOB_OWNER | VARCHAR2(256) | Specifies the job owner of the warning corrective action when WARNING_ACTION_TYPE is ÒCorrective-ActionÓ
WARNING_ACTION_JOB_NAME | VARCHAR2(64) | Specifies the job name of the warning corrective action when WARNING_ACTION_TYPE is ÒCorrective-ActionÓ
CRITICAL_ACTION_TYPE | VARCHAR2(17) | The critical corrective action type configured. Possible values are :No-Action : when no action is configuredCorrective-Action : when a repository side corrective action is configuredAgent-Fixit Job : when an agent side fix-it job is configured.
CRITICAL_ACTION_JOB_TYPE | VARCHAR2(32) | Specifies the job type of the critical corrective action when WARNING_ACTION_TYPE is ÒCorrective-ActionÓ.
CRITICAL_ACTION_JOB_OWNER | VARCHAR2(256) | Specifies the job owner of the critical corrective action when WARNING_ACTION_TYPE is ÒCorrective-ActionÓ.
CRITICAL_ACTION_JOB_NAME | VARCHAR2(64) | Specifies the job name of the critical corrective action when WARNING_ACTION_TYPE is ÒCorrective-ActionÓ.

Usage Notes

List all the metric setting for a given target.

List the metric settings for a given target and metric.

List the corrective actions assigned for a given target-metric.

### MGMT$AVAILABILITY_CURRENT

MGMT$AVAILABILITY_CURRENT displays information about the most recent target availability information stored in the Management Repository.

Table 6-10 MGMT$AVAILABILITY_CURRENT

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(64) | Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator.
TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics that are applicable for the target.
START_TIMESTAMP | DATE | The time when the target availability status change was first detected.
AVAILABILITY_STATUS | VARCHAR(15) | Current target availability status. This column contains one of the following values:² Target Down² Target Up² Metric Error² Agent Down² Unreachable² Blackout² Pending/Unknown

Usage Notes

Get the current availability status of a given target.

### MGMT$AVAILABILITY_HISTORY

MGMT$AVAILABILITY_HISTORY displays detailed historical information about changes in the availability status for a target over time.

Table 6-11 MGMT$AVAILABILITY_HISTORY

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(64) | Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator.
TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics that are applicable for the target.
TARGET_GUID | RAW(16) | The unique global identifier for the target.
START_TIMESTAMP | DATE | The time when the target availability status change was first detected.
END_TIMESTAMP | DATE | The time when the target availability status change was last detected.
AVAILABILITY_STATUS | VARCHAR2(10) | Target availability status. This column will contain one of the following values:² Target Down² Target Up² Metric Error² Agent Down² Unreachable² Blackout² Pending/Unknown

Usage Notes

Access to this view will use an index if the query references the member TARGET_ NAME, TARGET_TYPE and the START_TIMESTAMP.

### MGMT$ALERT_CURRENT

MGMT$ALERT_CURRENT displays current information for any alerts that are logged in the Management Repository that are in a non-clear state. Only the most recent open alert in a non-clear status for a given metric will be displayed through this view.

Table 6-12 MGMT$

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(64) | Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator.
TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics that are applicable for the target.
TARGET_GUID | RAW(16) | The unique global identifier for the target.
VIOLATION_GUID | RAW(16) | Unqiue identifier for the alert.
METRIC_NAME | VARCHAR2(64) | Name of the metric being defined.
METRIC_COLUMN | VARCHAR2(64) | For table metrics, the metric column contains the name of the column in the table that is being defined. If the metric that is being defined is not a table metric, the value in this column is a single space.For example, if this table describing the MGMT$TARGET_TYPE view was being defined as a table metric, Column Name, Data Type, and Description would be metric columns.
METRIC_LABEL | VARCHAR2(64) | An intuitive display name for the metric that is being defined.
COLUMN_LABEL | VARCHAR2(64) | For table metrics, the column label contains an intuitive display name for the metric column.
KEY_VALUE | VARCHAR2(256) | The key value for which the alert has been recorded. For composite keys, this is the first part of the key.
KEY_VALUE2 | VARCHAR2(256) | For composite keys, this is the second part of the key for which the alert has been recorded
KEY_VALUE3 | VARCHAR2(256) | For composite keys, this is the third part of the key for which the alert has been recorded
KEY_VALUE4 | VARCHAR2(256) | For composite keys, this is the fourth part of the key for which the alert has been recorded
KEY_VALUE5 | VARCHAR2(256) | For composite keys, this is the fifth part of the key for which the alert has been recorded
COLLECTION_ TIMESTAMP | DATE | The date-time when the alert condition was detected by the Management Agent.
ALERT_STATE | VARCHAR2(20) | A user readable description of the internal alert code that is sent from the Management Agent to identify the state of the alert condition. A alert record is transferred to the repository from the Management Agent each time the metric threshold is crossed in either direction, or if the Management Agent is restarted. The value of this column will contain one of the following strings:· Warning· CriticalIf the metric's alert condition goes into a clear state, it will no longer be visible from this view.
VIOLATION_TYPE | VARCHAR2(19) | A user readable description of the type of violation. Possible values are : Threshold Violation, when the alert is triggered based on a metric thresholdAvailability, when the alert is triggered for an availability metricPolicy Violation, when the alert is triggered based on a policy violation.
MESSAGE | VARCHAR2(1024) | An optional message that is generated when the alert is created that provides additional information about the alert condition.
MESSAGE_NLSID | VARCHAR2(64) | The nlsid of the alert message
MESSAGE_PARAMS | VARCHAR2(4000) | Contains the URL encoded parameters separated by "&" to be used to format the alert message.
ACTION_MESSAGE | VARCHAR2(4000) | Suggested action message in english for this alert
ACTION_MESSAGE_NLSID | VARCHAR2(64) | The NLS ID of the action message.
ACTION_MESSAGE_PARAMS | VARCHAR2(4000) | Contains the URL encoded parameters for translating action message
TYPE_DISPLAY_NAME | VARCHAR2(128) | The display name of the target type

Usage Notes

List the current alerts that are in a non-clear state for a metric, set of metrics, or for a managed target. If the user is only interested in non-clear alerts, counts or selects, using this view provide better performance than using the MGMT$ALERT_DETAILS view.

Access to this view will use an index if the query references the member target name, target type, metric name, and metric column or a subset of these columns if they are included as listed above from left to right.

### MGMT$ALERT_HISTORY

MGMT$ALERT_HISTORY displays historical information for any alerts that are logged in the Management Repository.

Table 6-13 MGMT$ALERT_HISTORY

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(64) | Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator.
TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics that are applicable for the target.
TARGET_GUID | RAW(16) | The unique global identifier for the target.
VIOLATION_GUID | RAW(16) | Unqiue identifier for the alert.
METRIC_NAME | VARCHAR2(64) | Name of the metric being defined.
METRIC_COLUMN | VARCHAR2(64) | For table metrics, the metric column contains the name of the column in the table that is being defined. If the metric that is being defined is not a table metric, the value in this column is a single space.For example, if this table describing the MGMT$TARGET_TYPE view was being defined as a table metric, Column Name, Data Type, and Description would be metric columns.
METRIC_LABEL | VARCHAR2(64) | An intuitive display name for the metric that is being defined.
COLUMN_LABEL | VARCHAR2(64) | For table metrics, the column label contains an intuitive display name for the metric column.
KEY_VALUE | VARCHAR2(256) | The key value for which the alert has been recorded. For composite keys, this is the first part of the key.
KEY_VALUE2 | VARCHAR2(256) | For composite keys, this is the second part of the key for which the alert has been recorded
KEY_VALUE3 | VARCHAR2(256) | For composite keys, this is the third part of the key for which the alert has been recorded
KEY_VALUE4 | VARCHAR2(256) | For composite keys, this is the fourth part of the key for which the alert has been recorded
KEY_VALUE5 | VARCHAR2(256) | For composite keys, this is the fifth part of the key for which the alert has been recorded
COLLECTION_ TIMESTAMP | DATE | The date-time when the alert condition was detected by the Management Agent.
ALERT_STATE | VARCHAR2(20) | A user readable description of the internal alert code that is sent from the Management Agent to identify the state of the alert condition. A alert record is transferred to the repository from the Management Agent each time the metric threshold is crossed in either direction, or if the Management Agent is restarted. The value of this column will contain one of the following strings:· Warning· CriticalIf the metric's alert condition goes into a clear state, it will no longer be visible from this view.
ALERT_DURATION | NUMBER | The time, in hours, from when the alert condition was first detected until it was cleared.
MESSAGE | VARCHAR2(1024) | An optional message that is generated when the alert is created that provides additional information about the alert condition.
MESSAGE_NLSID | VARCHAR2(64) | The nlsid of the alert message
MESSAGE_PARAMS | VARCHAR2(4000) | Contains the URL encoded parameters separated by "&" to be used to format the alert message.
ACTION_MESSAGE | VARCHAR2(4000) | Suggested action message in english for this alert
ACTION_MESSAGE_NLSID | VARCHAR2(64) | The NLS ID of the action message.
ACTION_MESSAGE_PARAMS | VARCHAR2(4000) | Contains the URL encoded parameters for translating action message
VIOLATION_TYPE | VARCHAR2(19) | An intuitive description of the type of violation. Possible values are : Threshold Violation: When the alert is triggered based on a metric thresholdAvailability: When the alert is triggered for an availability metricPolicy Violation: When the alert is triggered based on a policy violation.
TYPE_DISPLAY_NAME | VARCHAR2(128) | The display name of the target type

Usage Notes

List the historical details of alerts for a managed target or a specific metric ordered by time.

Determine the notification status for a specific alert or set of alerts.

Generate statistical reports on alert frequency using criteria such as by target, by metric, by groups of metrics.

Custom implementation of event filtering or causal analysis.

Custom aggregation (grouping) of alert information into categories.

Custom alert status queries or aggregations for specific time periods. i.e. What was my most problematic metric for target x last week? How many times did alert y occur between times w and x?

Generating time based histograms of alerts.

The view does not force any specific order on the rows returned. The assumption is that if the user wants to order the alert records that are returned in a specific way, they will add an order by clause to their select query.

Access to this view will use an index if the query references the member target name, target type, metric name, and metric column or a subset of these columns if they are included as listed above from left to right.

Queries that use the collection_timestamp or that query using the alert_state will also be indexed.

### MGMT$METRIC_DETAILS

MGMT$METRIC_DETAILS displays a rolling 25 hour window of individual metric samples. These are the metric values for the most recent sample that has been loaded into the Management Repository plus any earlier samples that have not been aggregated into hourly statistics.

Table 6-14 MGMT$METRIC_DETAILS

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(64) | Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator.
TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics that are applicable for the target.
TARGET_GUID | RAW(16) | The unique global identifier for the target.
METRIC_NAME | VARCHAR2(64) | Name of the metric being defined.
METRIC_TYPE | VARCHAR2(20) | A DECODE of the internal numeric type of the metric that is being defined. This column will contain one of the following values:NumberStringTableRawExternal
METRIC_COLUMN | VARCHAR2(64) | For table metrics, the metric column contains the name of the column in the table that is being defined. If the metric that is being defined is not a table metric, the value in this column is a single space.For example, if this table describing the MGMT$TARGET_TYPE view was being defined as a table metric, Column Name, Data Type, and Description would be metric columns.
METRIC_LABEL | VARCHAR2(64) | An intuitive display name for the metric that is being defined.
COLUMN_LABEL | VARCHAR2(64) | For table metrics, the column label contains an intuitive display name for the metric column.
COLLECTION_ TIMESTAMP | DATE | The date-time when the alert condition was detected by the Management Agent.
VALUE | VARCHAR2(4000) | Since current metric values can be a numeric or a string type, this column returns the value of the metric as a string. If the user of the view is restricting the query to numeric metric values, they can use the TO_NUMBER SQL function to return the values in numeric form.
KEY_VALUE | VARCHAR2(256) | The key value for which the alert has been recorded. For composite keys, this is the first part of the key.
KEY_VALUE2 | VARCHAR2(256) | For composite keys, this is the second part of the key for which the alert has been recorded
KEY_VALUE3 | VARCHAR2(256) | For composite keys, this is the third part of the key for which the alert has been recorded
KEY_VALUE4 | VARCHAR2(256) | For composite keys, this is the fourth part of the key for which the alert has been recorded
KEY_VALUE5 | VARCHAR2(256) | For composite keys, this is the fifth part of the key for which the alert has been recorded

Usage Notes

Show the individual values for a metric over time.

Identify time periods when abnormal samples for metric were collected.

Calculate the correlation coefficient between two or more metrics.

Provide metric values that are associated with an alert.

Queries using this view will use an index if the queries use the target name, the target type, metric name. metric column, and key value, or if they are based upon the collection_timestamp.

### MGMT$METRIC_CURRENT

MGMT$METRIC_CURRENT displays information on the most recent metric values that have been loaded into the Management Repository.

Table 6-15 MGMT$METRIC_CURRENT

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(64) | Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator.
TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics that are applicable for the target.
TARGET_GUID | RAW(16) | The unique global identifier for the target.
METRIC_NAME | VARCHAR2(64) | Name of the metric being defined.
METRIC_TYPE | VARCHAR2(20) | A DECODE of the internal numeric type of the metric that is being defined. This column will contain one of the following values:NumberStringTableRawExternal
METRIC_COLUMN | VARCHAR2(64) | For table metrics, the metric column contains the name of the column in the table that is being defined. If the metric that is being defined is not a table metric, the value in this column is a single space.For example, if this table describing the MGMT$TARGET_TYPE view was being defined as a table metric, Column Name, Data Type, and Description would be metric columns.
METRIC_LABEL | VARCHAR2(64) | An intuitive display name for the metric that is being defined.
COLUMN_LABEL | VARCHAR2(64) | For table metrics, the column label contains an intuitive display name for the metric column.
COLLECTION_ TIMESTAMP | DATE | The date-time when the alert condition was detected by the Management Agent.
VALUE | VARCHAR2(4000) | Since current metric values can be a numeric or a string type, this column returns the value of the metric as a string. If the user of the view is restricting the query to numeric metric values, they can use the TO_NUMBER SQL function to return the values in numeric form.
KEY_VALUE | VARCHAR2(256) | The key value for which the alert has been recorded. For composite keys, this is the first part of the key.
KEY_VALUE2 | VARCHAR2(256) | For composite keys, this is the second part of the key for which the alert has been recorded
KEY_VALUE3 | VARCHAR2(256) | For composite keys, this is the third part of the key for which the alert has been recorded
KEY_VALUE4 | VARCHAR2(256) | For composite keys, this is the fourth part of the key for which the alert has been recorded
KEY_VALUE5 | VARCHAR2(256) | For composite keys, this is the fifth part of the key for which the alert has been recorded

Usage Notes

Retrieve the most recent value for a metric that is stored in the Management Repository.

Retrieve the latest metrics for a target or metric for a specific time period.

Queries using this view will use an index if the queries use target name, the target type, metric name. metric column, and key value, or if they are based upon the collection_timestamp.

### MGMT$METRIC_HOURLY

MGMT$METRIC_HOURLY displays metric statistics information that have been aggregated from the individual metric samples into hourly time periods. For example, if a metric is collected every 15 minutes, the 1 hour rollup would aggregate the 4 samples into a single hourly value by averaging the 4 individual samples together. The current hour of statistics may not be immediately available from this view. The timeliness of the information provided from this view is dependent on when the query against the view was executed and when the hourly rollup table was last refreshed.

Table 6-16 MGMT$METRIC_HOURLY

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(64) | Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator.
TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics that are applicable for the target.
TARGET_GUID | RAW(16) | The unique global identifier for the target.
METRIC_NAME | VARCHAR2(64) | Name of the metric being defined.
METRIC_COLUMN | VARCHAR2(64) | For table metrics, the metric column contains the name of the column in the table that is being defined. If the metric that is being defined is not a table metric, the value in this column is a single space.For example, if this table describing the MGMT$TARGET_TYPE view was being defined as a table metric, Column Name, Data Type, and Description would be metric columns.
METRIC_LABEL | VARCHAR2(64) | An intuitive display name for the metric that is being defined.
COLUMN_LABEL | VARCHAR2(64) | For table metrics, the column label contains an intuitive display name for the metric column.
KEY_VALUE | VARCHAR2(256) | The key value for which the alert has been recorded. For composite keys, this is the first part of the key.
KEY_VALUE2 | VARCHAR2(256) | For composite keys, this is the second part of the key for which the alert has been recorded
KEY_VALUE3 | VARCHAR2(256) | For composite keys, this is the third part of the key for which the alert has been recorded
KEY_VALUE4 | VARCHAR2(256) | For composite keys, this is the fourth part of the key for which the alert has been recorded
KEY_VALUE5 | VARCHAR2(256) | For composite keys, this is the fifth part of the key for which the alert has been recorded
ROLLUP_TIMESTAMP | DATE | The rollup timestamp identifies the start of the rollup period. For the one-hour rollups, samples that fall within the hourly boundaries from minute 00 through minute 59 inclusive will be combined. For example, samples from 12:00 AM through 12:59 AM would be combined into a single aggregated record with a rollup timestamp of "date" 12:00 AM.
SAMPLE_COUNT | NUMBER | The number of non-NULL samples for the metric that were aggregated.
AVERAGE | NUMBER | The average of the metric values for the samples that have been included in the rollup period.
MINIMUM | NUMBER | The minimum value for the metric for the samples that have been included in the rollup period.
MAXIMUM | NUMBER | The maximum value for the metric for samples that have been included in the rollup period.
STANDARD_DEVIATION | NUMBER | The standard deviation for the metric values that have been included in the rollup period.

Usage Notes

This view provides the best level of granularity to show changes in a metric's value over the course of a day.

Identify hourly time periods when a metric or sets of metrics are maximized.

Understand how the variability of a metric over a one hour time period.

Identify the values of the collected metrics for a target when a particular hour has been identified as problematic.

Queries using this view will use an index if the queries use the target_name, the metric_name, or if they are based upon the rollup_timestamp.

### MGMT$METRIC_DAILY

MGMT$METRIC_DAILY displays metric statistics that have been aggregated from the samples collected over the previous twenty-four hour time period. The timeliness of the information provided from this view is dependent on when the query against the view was executed and when the hourly rollup table was last refreshed.

Table 6-17 MGMT$METRIC_DAILY

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(64) | Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator.
TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics that are applicable for the target.
TARGET_GUID | RAW(16) | The unique global identifier for the target.
METRIC_NAME | VARCHAR2(64) | Name of the metric being defined.
METRIC_COLUMN | VARCHAR2(64) | For table metrics, the metric column contains the name of the column in the table that is being defined. If the metric that is being defined is not a table metric, the value in this column is a single space.For example, if this table describing the MGMT$TARGET_TYPE view was being defined as a table metric, Column Name, Data Type, and Description would be metric columns.
METRIC_LABEL | VARCHAR2(64) | An intuitive display name for the metric that is being defined.
COLUMN_LABEL | VARCHAR2(64) | For table metrics, the column label contains an intuitive display name for the metric column.
KEY_VALUE | VARCHAR2(256) | The key value for which the alert has been recorded. For composite keys, this is the first part of the key.
KEY_VALUE2 | VARCHAR2(256) | For composite keys, this is the second part of the key for which the alert has been recorded
KEY_VALUE3 | VARCHAR2(256) | For composite keys, this is the third part of the key for which the alert has been recorded
KEY_VALUE4 | VARCHAR2(256) | For composite keys, this is the fourth part of the key for which the alert has been recorded
KEY_VALUE5 | VARCHAR2(256) | For composite keys, this is the fifth part of the key for which the alert has been recorded
ROLLUP_TIMESTAMP | DATE | The rollup timestamp identifies the start of the rollup period. For the one-hour rollups, samples that fall within the hourly boundaries from minute 00 through minute 59 inclusive will be combined. For example, samples from 12:00 AM through 12:59 AM would be combined into a single aggregated record with a rollup timestamp of "date" 12:00 AM.
SAMPLE_COUNT | NUMBER | The number of non-NULL samples for the metric that were aggregated.
AVERAGE | NUMBER | The average of the metric values for the samples that have been included in the rollup period.
MINIMUM | NUMBER | The minimum value for the metric for the samples that have been included in the rollup period.
MAXIMUM | NUMBER | The maximum value for the metric for samples that have been included in the rollup period.
STANDARD_DEVIATION | NUMBER | The standard deviation for the metric values that have been included in the rollup period.

Usage Notes

View provides the best granularity to show changes in a metric's value over the course of a week or month.

Understand trends in metric values.

Queries using this view will use an index if the queries use the target_name, the metric_name, or if they are based upon the rollup_timestamp.

## Inventory Views

### MGMT$TARGET

MGMT$TARGET displays information about the managed targets that are known to the Management Repository. These targets may or may not be actively monitored.

Table 6-18 MGMT$TARGET

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(64) | Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator.
TARGET_TYPE | VARCHAR2(64) | The type of the target. Types of targets may include databases, hosts, web servers, applications, or Application Servers. The definer of the collection definition at the Management Agent defines the target type. The target type defines the set of metrics that are collected for a managed target within the Management Repository.
TARGET_GUID | RAW(16) | The unique global identifier for the target.
TYPE_VERSION | VARCHAR2(8) | The target type meta version of the metadata set. Metadata versions may be updated when applying patches or upon new releases of Enterprise Manager Grid Control.
TYPE_QUALIFIER1-5 | VARCHAR2(64) | Up to five qualifiers can be used to distinguish different metric definitions based on different system configurations. Example qualifier entries may include operating system version, database version, or RAC configuration.
EMD_URL | VARCHAR2(2000) | The URL address of the Management Agent that is managing the target.
TIMEZONE_REGION | VARCHAR2(64) | The timezone region in which the target operates.
DISPLAY_NAME | VARCHAR2(64) | User-friendly name for the target.
HOST_NAME | VARCHAR2(128) | Name of the host where the target is running. For composite targets or targets that span a host, this column will be NULL.
LAST_METRIC_LOAD_TIME | TIMESTAMP | Timestamp when information for this target was last loaded into the Management Repository. If metrics have not been loaded into the Management Repository for the target, this column will be NULL.
TYPE_DISPLAY_NAME | VARCHAR2(128) | User-friendly name of the target type.

Usage Notes

Display a list of the targets known to the Management Repository.

Display administration and monitoring information in the context of a managed target.

Order the targets by last load time for customers to get a sense on how recent the information is for a target in the Management Repository. To access this information in an ordered way, customers should use the appropriate ORDER BY clause with the view.

Access to this view will use an index if the query references the target name and target type.

There is an implicit assumption that customers will not use this view to identify the targets that are owned by a Management Agent or the targets that reside on a specific host.

### MGMT$TARGET_TYPE

MGMT$TARGET_TYPE displays metric descriptions for a given target name and target type. This information is available for the metrics for the managed targets that have been loaded into the Management Repository. Metrics are specific to the target type.

Table 6-19 MGMT$TARGET_TYPE

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(64) | Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator.
TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics that are applicable for the target.
TARGET_GUID | RAW(16) | The unique global identifier for the target.
TYPE_VERSION | VARCHAR2(8) | The target type meta version of the metadata set. Metadata versions may be updated when applying patches or upon new releases of Enterprise Manager Grid Control.
TYPE_QUALIFIER1-5 | VARCHAR2(64) | Up to five qualifiers can be used to distinguish different metric definitions based on different system configurations. Example qualifier entries may include operating system version, database version, or RAC configuration.
METRIC_NAME | VARCHAR2(64) | The name of the metric that is being defined.
METRIC_COLUMN | VARCHAR2(64) | For table metrics, the metric column contains the name of the column in the table that is being defined. If the metric that is being defined is not a table metric, the value in this column is a single space. For example, if a table describing the MGMT$TARGET_TYPE view is to be defined as a table metric, Column Name, Data Type, and Description would be metric columns.
KEY_COLUMN | VARCHAR2(64) | For table metrics, the key column contains the name of the column in the table that represents the primary key. Values in this column must uniquely identify rows in the table. If the metric that is being defined is not a table metric, the value in this column is a single space; For example, the Column Name would be the key column if this table describing the MGMT$TARGET_TYPE view was being defined as a table metric.
METRIC_TYPE | VARCHAR2(20) | A DECODE of the internal numeric type of the metric that is being defined. This column will contain one of the following values: Number String Table Raw External Repository Metric
METRIC_LABEL | VARCHAR2(64) | A intuitive display name for the metric that is being defined.
COLUMN_LABEL | VARCHAR2(64) | For table metrics, the column label contains a user understandable display name for the metric column.
DESCRIPTION | VARCHAR2(128) | A description of the metric that is being defined.
DESCRIPTION_NLSID | VARCHAR2(64) | The NLSid of the description of the metric
UNIT | VARCHAR2(32) | The unit of the metric that is being defined.
UNIT_NLSID | VARCHAR2(64) | The NLSid of the unit of the metric being defined.
SHORT_NAME | VARCHAR2(40) | This is a shortened version of the metric display name for the "dense" UI concept
SHORT_NAME_NLSID | VARCHAR2(64) | The NLSid of the short name of the metric being defined.

Usage Notes

List the set of metrics that have been defined for a target type.

Display intuitive metric names and associated attributes such as unit in a general way during portal, web application, or custom 4GL report generation.

Access to this view will use an index if the query references the metric name, metric column. The query should also qualify the target name and target type in order to restrict the amount of information returned.

### MGMT$TARGET_TYPE_DEF

MGMT$TARGET_TYPE_DEF displays definition information for a target type.

Table 6-20 MGMT$TARGET_TYPE_DEF

Column | Datatype | Description
--- | --- | ---
TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics that are applicable for the target.
TYPE_DISPLAY_NAME | VARCHAR2(128) | User-friendly name of the target type.
TARGET_TYPE_GUID | RAW(16) | The unique global identifier (GUID) of the target type .
MAX_TYPE_META_VER | VARCHAR2(8) | The maximum verision of the target type stored in the Management Repository.

### MGMT$TARGET_ASSOCIATIONS

MGMT$TARGET_ASSOCIATIONS displays the various associations between targets. This view can be used to find all types of associations for a given target.

Table 6-21 MGMT$TARGET_ASSOCIATIONS

Column | Datatype | Description
--- | --- | ---
ASSOC_DEF_NAME | VARCHAR2(64) | Name of the association definition.
SOURCE_TARGET_NAME | VARCHAR2(256) | Target name of the target to which the association is being defined.
SOURCE_TARGET_TYPE | VARCHAR2(64) | The target type of the target for which the association is being defined. ÒANYÓ can be used to specify that any target type be used.
ASSOC_TARGET_NAME | VARCHAR2(256) | Target Name of the target which is being associated with the source target.
ASSOC_TARGET_TYPE | VARCHAR2(64) | The target type of the associated target. ÒANYÓ can be used to specify that any target type be used.
SCOPE_TARGET_NAME | VARCHAR2(256) | The target under whose scope the association is valid. This applies to non-global associations only. For example: A database may be part of a composite target only for a particular service.
SCOPE_TARGET_TYPE | VARCHAR2(64) | The target type for which the association is valid. This applies to non-global associations only.
ASSOCIATION_TYPE | VARCHAR2(64) | The type of association.

Usage Notes

Can be used to list the associations defined for a specific target.

Queries using this view will use an index if either (source_target_name, source_target_type) or (assoc_target_name, assoc_target_type) is specified.

### MGMT$TARGET_MEMBERS

MGMT$TARGET_MEMBERS displays the list of direct members for a target.

Table 6-22 MGMT$TARGET_MEMBERS

Column | Datatype | Description
--- | --- | ---
AGGREGATE_TARGET_NAME | VARCHAR2(256) | Target name of the aggregate target.
AGGREGATE_TARGET_TYPE | VARCHAR2(64) | Target type of the aggregate target.
AGGREGATE_TARGET_GUID | RAW(16) | Target GUID of the aggregate target.
MEMBER_TARGET_NAME | VARCHAR2(256) | Target Name of the member target.
MEMBER_TARGET_TYPE | VARCHAR2(64) | Target type of the member target.
MEMBER_TARGET_GUID | RAW(16) | Target GUID of the member target.

Usage Notes

Find the members for a aggregate target.

Find the aggregate targets for which a given target is a direct member.

Queries, which specify values for (AGGREGATE_TARGET_NAME, AGGREGATE_TARGET_TYPE) or (MEMBER_TARGET_NAME, MEMBER_TARGET_TYPE) will use index.

Joins using AGGREGATE_TARGET_GUID and MEMBER_TARGET_GUID will be efficient.

### MGMT$TARGET_FLAT_MEMBERS

MGMT$TARGET_FLAT_MEMBERS displays the list of all direct and indirect members of the target.

Table 6-23 MGMT$TARGET_FLAT_MEMBERS

Column | Datatype | Description
--- | --- | ---
AGGREGATE_TARGET_NAME | VARCHAR2(256) | The target name of the aggregate target
AGGREGATE_TARGET_TYPE | VARCHAR2(64) | The target type of the aggregate target
AGGREGATE_TARGET_GUID | RAW(16) | Target GUID of the aggregate target
MEMBER_TARGET_NAME | VARCHAR2(256) | Target Name of the member target
MEMBER_TARGET_TYPE | VARCHAR2(64) | Target type of the member target
MEMBER_TARGET_GUID | RAW(16) | Target GUID of the member target

Usage Notes

Find the members for a aggregate target.

Find the aggregate targets for which a given target is a member either directly or indirectly.

Queries, which specify values for (AGGREGATE_TARGET_NAME, AGGREGATE_TARGET_TYPE) or (MEMBER_TARGET_NAME, MEMBER_TARGET_TYPE) will use index.

Joins using AGGREGATE_TARGET_GUID and MEMBER_TARGET_GUID will be the most efficient on this view.

### MGMT$TARGET_TYPE_PROPERTIES

MGMT$TARGET_TYPE_PROPERTIES displays the default list of properties that are applicable to the target based on the target type to which the target belongs.

Table 6-24 MGMT$TARGET_TYPE_PROPERTIES

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(256) | Name of the target.
TARGET_TYPE | VARCHAR2(64) | Name of the target type.
PROPERTY_NAME | VARCHAR2(64) | Name of the property, Example:is_aggregate,is_service, IsBaselineable.
PROPERTY_VALUE | VARCHAR2(1024) | Value of the property

Usage Notes

List the properties applicable to the target and the default values.

### MGMT$TARGET_PROPERTIES

MGMT$TARGET_PROPERTIES displays detailed target properties.

Table 6-25 MGMT$

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(256) | Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator.
TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics that are applicable for the target.
TARGET_GUID | RAW(16) | The unique global identifier for the target.
PROPERTY_NAME | VARCHAR2(64) | The name of the target property being defined.
PROPERTY_VALUE | VARCHAR2(1024) | The value of the target property being defined.
PROPERTY_TYPE | VARCHAR2(64) | The type of the target property being defined. Possible values are: INSTANCE, if the property is applicable to the target instance. DYNAMIC, if the property is calculated dynamically.

### MGMT$METRIC_CATEGORIES

MGMT$METRIC_CATEGORIES displays the list of classes and categories to which the metric belongs. This view can be used to classify the metric based on the class (Example: Service, Functional) and category within the class (Example: security/configuration under functional class or usage/performance under service class).

Table 6-26 MGMT$METRIC_CATEGORIES

Column | Datatype | Description
--- | --- | ---
TARGET_TYPE | VARCHAR2(64) | Name of the target type.
TYPE_VERSION | VARCHAR2(8) | Version of the target type.
METRIC_NAME | VARCHAR2(64) | Name of the metric.
METRIC_COLUMN | VARCHAR2(64) | For table metrics, the metric column contains the name of the column in the table that is being defined. If the metric that is being defined is not a table metric, the value in this column is a single space.
METRIC_CLASS_NAME | VARCHAR2(64) | Name of the metric class to which this metric belongs.
METRIC_CATEGORY_NAME | VARCHAR2(64) | Name of the category of the metric in the class.
METRIC_CATEGORY_NLSID | VARCHAR2(64) | The NLS ID of the category which is used by Enterprise Manager to translate the name to different languages.

Usage Notes

Classify the metrics into different buckets based on Class and category.

## Policy Definition Views

### MGMT$POLICIES

MGMT$POLICIES displays the list of policies defined in the Management Repository.

Table 6-27 MGMT$POLICIES

Column | Datatype | Description
--- | --- | ---
TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics and polciies that are applicable for the target.
METRIC_NAME | VARCHAR2(64) | The name of the metric based on which the policy is defined.
POLICY_NAME | VARCHAR2(128) | The name of the policy being defined.
POLICY_LABEL_NLSID | VARCHAR2(64) | The NSL ID for the policy name.
POLICY_GUID | RAW(16) | The unique global identifier for the policy.
AUTHOR | VARCHAR2(256) | The author of the policy.
DESCRIPTION | VARCHAR2(256) | The description of the policy.
DESCRIPTION_NLSID | VARCHAR2(64) | The NLS ID of the description.
IMPACT | VARCHAR2(500) | A description of th e impact of the policy being defined.
IMPACT_NLSID | VARCHAR2(64) | NLSid for the policy impact.
RECOMMENDATION | VARCHAR2(500) | A recommendation for the policy being defined.
RECOMMENDATION_NLSID | VARCHAR2(64) | NLS ID for the policy recommendataion.
VIOLATION_LEVEL | VARCHAR2(13) | The level at which the violations will be logged when the policy being defined is violated. Possible values are : Informational Warning Critical
CONDITION_TYPE | NUMBER(1) | The type condition used by the the policy being defined. Possible values are : 1. Simple condition 2. SQL expression condition 3. PL/SQL procedure for evaluating condition.
CONDITION | VARCHAR2(4000) | The conidtion details / expression used by the policy being defined. If the condition type is 1, this column contains the metric_column_name 2, this column contains the conditional expression 3, this column contains the pl/sql procedure name that peforms the condition.
CONDITION_OPERATOR | NUMBER | Defines the policy condition operator to be applied, when the condition_type is 'Simple Condition'. Possible values are : 0 - GT 1 - EQ 2 - LT 3 - LE 4 - GE 5 - CONTAINS 6 - NE 7 - MATCH : regular expression
OWNER | VARCHAR2(256) | The Enterprise Manager administrator who created the policy in the repository.
AUTO_ENABLED | NUMBER(1) | Specifies whether the policy should be enable automatically on the new targets that are being added.
CATEGORY | VARCHAR2(64) | The name of the category the policy. Refer to MGMT$METRIC_CATEGORIES for the list of all categories.
CATEGORY_NLSID | VARCHAR2(64) | The NLSid of the policy category.

### MGMT$POLICY_PARAMETERS

MGMT$POLICY_PARAMETERS displays detailed information about a policy.

Table 6-28 MGMT$POLICY_PARAMETERS

Column | Datatype | Description
--- | --- | ---
TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics and polciies that are applicable for the target.
METRIC_NAME | VARCHAR2(64) | The name of the metric based on which the policy is defined.
POLICY_NAME | VARCHAR2(128) | The name of the policy being defined.
POLICY_GUID | RAW(16) | The unique global identifier for the policy.
PARAMETER_NAME | VARCHAR2(64) | The name of the policy parameter
PARAMETER_NAME_NLSID | VARCHAR2(64) | The NLSid of the policy parameter.
PARAMETER_TYPE | VARCHAR2(7) | The type of the policy parameter. Possible values are : 1 for NUMERIC parameter 2 for STRING parameter

### MGMT$POLICY_VIOLATION_CTXT

MGMT$POLICY_VIOLATION_CTXT displays the policy violation context.

Table 6-29 MGMT$POLICY_VIOLATION_CTXT

Column | Datatype | Description
--- | --- | ---
TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics and polciies that are applicable for the target
METRIC_NAME | VARCHAR2(64) | The name of the metric based on which the policy is defined.
POLICY_NAME | VARCHAR2(128) | The name of the policy being defined.
POLICY_GUID | RAW(16) | The unique global identifier for the policy.
COLUMN_NAME | VARCHAR2(64) | The column name to be included in the policy violation context.
IS_HIDDEN | NUMBER(1) | Flag indicating whether or not the value for this metric (data source) column should be displayed when viewing a violation. Default 0.
URL_LINK_TYPE | VARCHAR2(7) | Flag indicating the type of the link. Possible values : JSP UIX
URL_LINK_TEMPLATE | VARCHAR2(4000) | URL template that contains references to any metric (data source) column name defined in the metric (data source). The actual values are substituted in at run-time to construct a URL that is associated with this metric columns value. Default NULL.

### MGMT$TARGET_POLICY_EVAL_SUMM

MGMT$TARGET_POLICY_EVAL_SUMM displays the policy violation summary for a target.

Table 6-30 MGMT$TARGET_POLICY_EVAL_SUMM

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(256) | Name of the target for which the policies were being evaluated. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator.
TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics and policies that are applicable for the target
TARGET_GUID | RAW(16) | The unique global identifier for the target..
POLICY_NAME | VARCHAR2(128) | The name of the policy for which evaluation summary is provided.
POLICY_GUID | RAW(16) | The unique global identifier for the policy.
COLL_NAME | VARCHAR2(64) | The name of the collection on which the policy is evaluated.
LAST_EVALUATION_DATE | DATE | The last date on which the policy was evaluated for the target for the collection item.
TOTAL_VIOLATIONS | NUMBER | The number of violations logged for the given target policy association
NON_SUPPRESS_VIOLATIONS | NUMBER | The number of non-exempt violations logged for the given target policy association.
COMPLIANCE_SCORE | NUMBER | The compliance score calculated for the target policy association.

### MGMT$POLICY_VIOL_ANNOTATIONS

MGMT$POLICY_VIOL_ANNOTATIONS displays a summary of policy violation annotations.

Table 6-31 MGMT$POLICY_VIOL_ANNOTATIONS

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(256) | Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator.
TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics that are applicable for the target.
TARGET_GUID | RAW(16) | The unique global identifier for the target.
POLICY_NAME | VARCHAR2(128) | The name of the policy rule
DESCRIPTION | VARCHAR2(256) | A description of the policy rule
KEY_VALUE | VARCHAR2(256) | The key value for which the alert has been recorded. For composite keys, this is the first part of the key.
KEY_VALUE2 | VARCHAR2(256) | For composite keys, this is the second part of the key for which the alert has been recorded
KEY_VALUE3 | VARCHAR2(256) | For composite keys, this is the third part of the key for which the alert has been recorded
KEY_VALUE4 | VARCHAR2(256) | For composite keys, this is the fourth part of the key for which the alert has been recorded
KEY_VALUE5 | VARCHAR2(256) | For composite keys, this is the fifth part of the key for which the alert has been recorded
MESSAGE | VARCHAR2(4000) | The policy violation message.
VIOLATION_LEVEL | VARCHAR2(40) | A user readable description of the internal violation code that is sent from the Management Agent to identify the state of the policy violation. A policy violation record is transferred to the repository from the Management Agent each time the metric threshold is crossed in either direction, or if the Management Agent is restarted. The value of this column will contain one of the following strings: · Clear · Critical
COLLECTION_TIMESTAMP | DATE | The date-time when the policy violation was detected by the Management Agent.
ANNOTATION_MESSAGE | VARCHAR2(4000) | The annotation text.
ANNOTATION_TIMESTAMP | DATE | The time the annotation was created.
ANNOTATED_BY | VARCHAR2(256) | Enterprise Manager administrator who authored the the annotation.

### MGMT$POLICY_VIOL_NOTIF_LOG

MGMT$POLICY_VIOL_NOTIF_LOG displays details of notification deliveries for policy violations.

Table 6-32 MGMT$POLICY_VIOL_NOTIF_LOG

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(256) | Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator.
TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics that are applicable for the target.
TARGET_GUID | RAW(16) | The unique global identifier for the target.
POLICY_NAME | VARCHAR2(128) | The name of the policy rule
KEY_VALUE | VARCHAR2(256) | The key value for which the alert has been recorded. For composite keys, this is the first part of the key.
KEY_VALUE2 | VARCHAR2(256) | For composite keys, this is the second part of the key for which the alert has been recorded
KEY_VALUE3 | VARCHAR2(256) | For composite keys, this is the third part of the key for which the alert has been recorded
KEY_VALUE4 | VARCHAR2(256) | For composite keys, this is the fourth part of the key for which the alert has been recorded
KEY_VALUE5 | VARCHAR2(256) | For composite keys, this is the fifth part of the key for which the alert has been recorded
VIOLATION_MESSAGE | VARCHAR2(4000) | A user readable description of the internal violation code that is sent from the Management Agent to identify the state of the policy violation. A policy violation record is transferred to the repository from the Management Agent each time the metric threshold is crossed in either direction, or if the Management Agent is restarted. The value of this column will contain one of the following strings: · Clear · Critical
VIOLATION_LEVEL | VARCHAR2(40) | A user readable description of the internal violation code that is sent from the Management Agent to identify the state of the policy violation. A policy violation record is transferred to the repository from the Management Agent each time the metric threshold is crossed in either direction, or if the Management Agent is restarted. The value of this column will contain one of the following strings: · Clear · Critical
COLLECTION_TIMESTAMP | DATE | The date-time when the policy violation was detected by the Management Agent.
DELIVERY_MESSAGE | VARCHAR2(1024) | The message indicating the success or failure of the notification delivery.
DELIVERY_TIMESTAMP | DATE | The date-time when the notification was delivered.

## Policy Association Views

### MGMT$TARGET_POLICIES

MGMT$TARGET_POLICIES displays target policy information.

Table 6-33 MGMT$TARGET_POLICIES

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(256) | Name of the target for which the policies were being evaluated. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator.
TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics and policies that are applicable for the target
TARGET_GUID | RAW(16) | The unique global identifier for the target.
POLICY_NAME | VARCHAR2(128) | The name of the policy that is associated with the target.
POLICY_GUID | RAW(16) | The unique global identifier for the policy.
CATEGORY | VARCHAR2(64) | The name of the category the policy. Refer to MGMT$METRIC_CATEGORIES for the list of all categories.
IS_ENABLED | NUMBER(1) | Flag to indicate whether the policy is enabled or disabled on the target.

### MGMT$TARGET_POLICY_SETTINGS

MGMT$TARGET_POLICY_SETTINGS displays policy settings for a target.

Table 6-34 MGMT$TARGET_POLICY_SETTINGS

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(256) | Name of the target for which the policies were being evaluated. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator.
TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics and policies that are applicable for the target
TARGET_GUID | RAW(16) | The unique global identifier for the target.
POLICY_NAME | VARCHAR2(128) | The name of the policy that is associated with the target.
POLICY_GUID | RAW(16) | The unique global identifier for the policy.
CATEGORY | VARCHAR2(64) | The name of the category the policy. Refer to MGMT$METRIC_CATEGORIES for the list of all categories.
KEY_VALUE | VARCHAR2(256) | The key value for which the alert has been recorded. For composite keys, this is the first part of the key.
KEY_VALUE2 | VARCHAR2(256) | For composite keys, this is the second part of the key for which the alert has been recorded
KEY_VALUE3 | VARCHAR2(256) | For composite keys, this is the third part of the key for which the alert has been recorded
KEY_VALUE4 | VARCHAR2(256) | For composite keys, this is the fourth part of the key for which the alert has been recorded
KEY_VALUE5 | VARCHAR2(256) | For composite keys, this is the fifth part of the key for which the alert has been recorded
KEY_OPERATOR | NUMBER | Specifies whether the key_value columns have any SQL wildcards. For single key column metrics, the value is 1 if the key_value has wildcard characters, 0 otherwise. For metrics with multiple keys, a list of operators for all key columns will be stored here. For example, a metric with 3 keys (k1, k2, k3) where K1 and K2 use wildcards and K3 uses exact match, then 011 is stored in this column
PARAMETER_NAME | VARCHAR2(64) | The name of the policy parameter.
PREVENT_OVERRIDE | NUMBER(1) | The is a flag that specifies that the metric rows with this key_value has a tempalte override flag. Once the tempalte override flag is ON, any template application will not update the threshold/parameter values.
POLICY_THRESHOLD | VARCHAR2(256) | The threshold value for the policy parameter.
ACTION_TYPE | VARCHAR2(17) | The corrective action type configured. Possible values are : No-Action : when no action is configured Corrective-Action : when a repository side corrective action is configured Agent-Fixit Job : when an agent side fix-it job is configured.
ACTION_JOB_TYPE | VARCHAR2(32) | Specifies the job type of the corrective action when ACTION_TYPE is ÒCorrective-ActionÓ.
ACTION_JOB_NAME | VARCHAR2(64) | Specifies the job name of the corrective action when ACTION_TYPE is ÒCorrective-ActionÓ.
ACTION_JOB_OWNER | VARCHAR2(256) | Specifies the job owner of the corrective action when ACTION_TYPR is ÒCorrective-ActionÓ.

## Policy Violation Views

### MGMT$POLICY_VIOLATION_CURRENT

MGMT$POLICY_VIOLATION_CURRENT displays current information for any policy violations that are logged in the Management Repository that are in a non-clear state. Only the most recent open violation in a non-clear status for a given policy will be provided through this view.

Table 6-35 MGMT$POLICY_VIOLATION_CURRENT

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(256) | Name of the target for which the policies were being evaluated. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator.
TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics and policies that are applicable for the target
TYPE_DISPLAY_NAME | VARCHAR2(128) | User-friendly name of the target type.
TARGET_GUID | RAW(16) | The unique global identifier for the target.
POLICY_NAME | VARCHAR2(128) | The name of the policy that is associated with the target.
POLICY_GUID | RAW(16) | The unique global identifier for the policy.
CATEGORY | VARCHAR2(64) | The name of the category the policy. Refer to MGMT$METRIC_CATEGORIES for the list of all categories.
KEY_VALUE | VARCHAR2(256) | The key value for which the alert has been recorded. For composite keys, this is the first part of the key.
KEY_VALUE2 | VARCHAR2(256) | For composite keys, this is the second part of the key for which the alert has been recorded
KEY_VALUE3 | VARCHAR2(256) | For composite keys, this is the third part of the key for which the alert has been recorded
KEY_VALUE4 | VARCHAR2(256) | For composite keys, this is the fourth part of the key for which the alert has been recorded
KEY_VALUE5 | VARCHAR2(256) | For composite keys, this is the fifth part of the key for which the alert has been recorded
COLLECTION_TIMESTAMP | DATE | The date-time when the policy violation condition was detected.
VIOLATION_LEVEL | NUMBER | A user readable description of the internal violation level logged to identify the state of the policy condition. A violation record is logged each time the policy condition is violated in either direction. The value of this column will contain one of the following strings: . Informational · Warning · Critical If the policy condition goes into a clear state, it will no longer be visible from this view.
MESSAGE | VARCHAR2(4000) | An optional message that is generated when the violation is logged that provides additional information about the policy condition.
MESSAGE_NLSID | VARCHAR2(64) | The NLSid of the message.
MESSAGE_PARAMS | VARCHAR2(4000) | Contains the URL encoded parameters separated by "&" to be used to format the alert message.
SUPPRESS_CODE | NUMBER | Indication of exemption status. Legal values: 0 - not exempt 1 - exempt indefinitely 2 - exempt until date specified in SUPPRESS_UNTIL 3 - exempt until next evaluation Default 0'
SUPPRESS_UNTIL | DATE | Specifies the date until which exemption should be applied. Only application if SUPPRESS_CODE is 2
SUPPRESS_BY | VARCHAR2(256) | Enterprise Manager adminstrator that suppressed the violation.

### MGMT$POLICY_VIOLATION_HISTORY

MGMT$POLICY_VIOLATION_HISTORY displays historical information for any policies that are logged in the Management Repository.

Table 6-36 MGMT$POLICY_VIOLATION_HISTORY

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(256) | Name of the target for which the policies were being evaluated. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator.
TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics and policies that are applicable for the target
TYPE_DISPLAY_NAME | VARCHAR2(128) | User-friendly name of the target type.
TARGET_GUID | RAW(16) | The unique global identifier for the target.
POLICY_NAME | VARCHAR2(128) | The name of the policy that is associated with the target.
POLICY_GUID | RAW(16) | The unique global identifier for the policy.
CATEGORY | VARCHAR2(64) | The name of the category the policy. Refer to MGMT$METRIC_CATEGORIES for the list of all categories.
KEY_VALUE | VARCHAR2(256) | The key value for which the alert has been recorded. For composite keys, this is the first part of the key.
KEY_VALUE2 | VARCHAR2(256) | For composite keys, this is the second part of the key for which the alert has been recorded
KEY_VALUE3 | VARCHAR2(256) | For composite keys, this is the third part of the key for which the alert has been recorded
KEY_VALUE4 | VARCHAR2(256) | For composite keys, this is the fourth part of the key for which the alert has been recorded
KEY_VALUE5 | VARCHAR2(256) | For composite keys, this is the fifth part of the key for which the alert has been recorded
COLLECTION_TIMESTAMP | DATE | The date-time when the policy violation condition was detected.
VIOLATION_LEVEL | NUMBER | A user readable description of the internal violation level logged to identify the state of the policy condition. A violation record is logged each time the policy condition is violated in either direction. The value of this column will contain one of the following strings: . Informational · Warning · Critical If the policy condition goes into a clear state, it will no longer be visible from this view.
VIOLATION_DURATION | NUMBER | The time, in hours, from when the policy condition was first detected until it was cleared.
MESSAGE | VARCHAR2(4000) | An optional message that is generated when the violation is logged that provides additional information about the policy condition.
MESSAGE_NLSID | VARCHAR2(64) | NLSid of the policy message.
MESSAGE_PARAMS | VARCHAR2(4000) | Contains the URL encoded parameters separated by "&" to be used to format the policy message.

### MGMT$POLICY_VIOLATION_CONTEXT

MGMT$POLICY_VIOLATION_CONTEXT displays policy violation context.

Table 6-37 MGMT$POLICY_VIOLATION_CONTEXT

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(256) | Name of the target for which the policies were being evaluated. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator.
TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics and policies that are applicable for the target
TYPE_DISPLAY_NAME | VARCHAR2(128) | User-friendly name of the target type.
TARGET_GUID | RAW(16) | The unique global identifier for the target.
POLICY_NAME | VARCHAR2(128) | The name of the policy that is associated with the target.
POLICY_GUID | RAW(16) | The unique global identifier for the policy.
CATEGORY | VARCHAR2(64) | The name of the category the policy. Refer to MGMT$METRIC_CATEGORIES for the list of all categories.
KEY_VALUE | VARCHAR2(256) | The key value for which the alert has been recorded. For composite keys, this is the first part of the key.
KEY_VALUE2 | VARCHAR2(256) | For composite keys, this is the second part of the key for which the alert has been recorded
KEY_VALUE3 | VARCHAR2(256) | For composite keys, this is the third part of the key for which the alert has been recorded
KEY_VALUE4 | VARCHAR2(256) | For composite keys, this is the fourth part of the key for which the alert has been recorded
KEY_VALUE5 | VARCHAR2(256) | For composite keys, this is the fifth part of the key for which the alert has been recorded
COLLECTION_TIMESTAMP | DATE | The date-time when the policy violation condition was detected.
COLUMN_NAME | VARCHAR2(64) | The associated name stored along with the policy violation.
COLUMN_VALUE | VARCHAR2(4000) | The associated value stored along with the policy violation.

## Management Template Views

### MGMT$TEMPLATES

MGMT$TEMPLATES displays details of all the management templates stored in the Management Repository.

Table 6-38 MGMT$TEMPLATES

Column | Datatype | Description
--- | --- | ---
TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics and policies that are applicable for the target
TEMPLATE_NAME | VARCHAR2(64) | The name of the template.
TEMPLATE_GUID | RAW(16) | The unique global identifier for the template.
DESCRIPTION | VARCHAR2(1024) | The description of the template.
OWNER | VARCHAR2(256) | Enterprise Manager administrator who owns the template.
IS_PUBLIC | NUMBER(1) | The flag to specify whether the template is accessible to all EM administrators.
CREATED_DATE | DATE | The date/time when the template is created in the repository.
LAST_UPDATED_DATE | DATE | The date/time when the template was last modified in the repository.
LAST_UPDATED_BY | VARCHAR2(256) | The EM administrator who last updated the template.

### MGMT$TEMPLATE_POLICY_SETTINGS

MGMT$TEMPLATE_POLICY_SETTINGS displays policy settings for management templates.

Table 6-39 MGMT$TEMPLATE_POLICY_SETTINGS

Column | Datatype | Description
--- | --- | ---
TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics and policies that are applicable for the target
TEMPLATE_NAME | VARCHAR2(64) | The name of the template.
TEMPLATE_GUID | RAW(16) | The unique global identifier for the template.
POLICY_NAME | VARCHAR2(128) | The name of the policy that is associated with the template.
POLICY_GUID | RAW(16) | The unique global identifier for the policy.
CATEGORY | VARCHAR2(64) | The name of the category the policy. Refer to MGMT$METRIC_CATEGORIES for the list of all categories.
KEY_VALUE | VARCHAR2(256) | The key value for which the alert has been recorded. For composite keys, this is the first part of the key.
KEY_VALUE2 | VARCHAR2(256) | For composite keys, this is the second part of the key for which the alert has been recorded
KEY_VALUE3 | VARCHAR2(256) | For composite keys, this is the third part of the key for which the alert has been recorded
KEY_VALUE4 | VARCHAR2(256) | For composite keys, this is the fourth part of the key for which the alert has been recorded
KEY_VALUE5 | VARCHAR2(256) | For composite keys, this is the fifth part of the key for which the alert has been recorded
KEY_OPERATOR | NUMBER | Specifies whether the key_value columns have any SQL wildcards. For single key column metrics, the value is 1 if the key_value has wildcard characters, 0 otherwise. For metrics with multiple keys, a list of operators for all key columns will be stored here. For example, a metric with 3 keys (k1, k2, k3) where K1 and K2 use wildcards and K3 uses exact match, then 011 is stored in this column
PARAMETER_NAME | VARCHAR2(64) | The name of the parameter.
PREVENT_OVERRIDE | NUMBER(1) | The is a flag that specifies that the metric rows with this key_value has a tempalte override flag. Once the tempalte override flag is ON, any template application will not update the threshold/parameter values.
POLICY_THRESHOLD | VARCHAR2(256) | The threshold value confugured for the policy parameter.
ACTION_TYPE | VARCHAR2(17) | The corrective action type configured. Possible values are : No-Action : when no action is configured Corrective-Action : when a repository side corrective action is configured Agent-Fixit Job : when an agent side fix-it job is configured.
ACTION_JOB_TYPE | VARCHAR2(32) | Specifies the job type of the corrective action when ACTION_TYPE is ÒCorrective-ActionÓ.
ACTION_JOB_NAME | VARCHAR2(64) | Specifies the job name of the corrective action when ACTION_TYPE is ÒCorrective-ActionÓ.
ACTION_JOB_OWNER | VARCHAR2(256) | Specifies the job owner of the corrective action when ACTION_TYPE is ÒCorrective-ActionÓ.

### MGMT$TEMPLATE_METRICCOLLECTION

MGMT$TEMPLATE_METRICCOLLECTIONS displays information on the metric collections defined for a template.

Table 6-40 MGMT$TEMPLATE_METRICCOLLECTION

Column | Datatype | Description
--- | --- | ---
TEMPLATE_NAME | VARCHAR2(64) | The name of the template.
TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics and policies that are applicable for the target
TEMPLATE_GUID | RAW(16) | The unique global identifier for the template.
METRIC_NAME | VARCHAR2(64) | The name of the metric for which the template collection is configured.
METRIC_COLUMN | VARCHAR2(64) | The name of the metric column for which the template collection is configured.
METRIC_GUID | RAW(16) | The unique global identifier for the metric column.
COLLECTION_NAME | VARCHAR2(64) | The name of the collection.
IS_REPOSITORY | NUMBER(1) | Indicates whether this is a repository-side collection. A repository-side collection has a PL/SQL evaluation procedure that is responsible for calculating the metric values.
FREQUENCY_CODE | VARCHAR2(9) | The metric collection frequency type. Possible values are: 1: One Time 2: Interval 3: Daily 4: Weekly 5: Monthly 6: Yearly 7: On Demand
COLLECTION_FREQUENCY | VARCHAR2(81) | The frequency of the metric collection. Value displayed is dependent on the frequency code: For One Time, the start date-time is stored in DD-MON-YY HH24:MI format. For Interval type, the frequency in minutes is stored. For Daily/Weekly/Monthly/Yearly types, the hour and minute of collection is stored in HH24:MI format. For On-Demand type, On-Demand is stored.
UPLOAD_POLICY | NUMBER | The frequency with which the metric data is uploaded/stored.

### MGMT$TEMPLATE_METRIC_SETTINGS

MGMT$TEMPLATE_METRIC_SETTINGS displays management template settings.

Table 6-41 MGMT$TEMPLATE_METRIC_SETTINGS

Column | Datatype | Description
--- | --- | ---
TEMPLATE_NAME | VARCHAR2(64) | The name of the template.
TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics and policies that are applicable for the target
TEMPLATE_GUID | RAW(16) | The unique global identifier for the template.
METRIC_NAME | VARCHAR2(64) | The name of the metric for which the template collection is configured.
METRIC_COLUMN | VARCHAR2(64) | The name of the metric column for which the template collection is configured.
METRIC_GUID | RAW(16) | The unique global identifier for the metric column.
COLLECTION_NAME | VARCHAR2(64) | The name of the collection.
CATEGORY | VARCHAR2(64) | The name of the category the policy. Refer to MGMT$METRIC_CATEGORIES for the list of all categories.
KEY_VALUE | VARCHAR2(256) | The key value for which the alert has been recorded. For composite keys, this is the first part of the key.
KEY_VALUE2 | VARCHAR2(256) | For composite keys, this is the second part of the key for which the alert has been recorded
KEY_VALUE3 | VARCHAR2(256) | For composite keys, this is the third part of the key for which the alert has been recorded
KEY_VALUE4 | VARCHAR2(256) | For composite keys, this is the fourth part of the key for which the alert has been recorded
KEY_VALUE5 | VARCHAR2(256) | For composite keys, this is the fifth part of the key for which the alert has been recorded
KEY_OPERATOR | NUMBER | Specifies whether the key_value columns have any SQL wildcards. For single key column metrics, the value is 1 if the key_value has wildcard characters, 0 otherwise. For metrics with multiple keys, a list of operators for all key columns will be stored here. For example, a metric with 3 keys (k1, k2, k3) where K1 and K2 use wildcards and K3 uses exact match, then 011 is stored in this column
PREVENT_OVERRIDE | NUMBER(1) | The is a flag that specifies that the metric rows with this key_value has a tempalte override flag. Once the tempalte override flag is ON, any template application will not update the threshold/parameter values.
WARNING_OPERATOR | NUMBER | Defines the warning threshold condition to be applied 0 - GT 1 - EQ 2 - LT 3 - LE 4 - GE 5 - CONTAINS 6 - NE 7 - MATCH : regular expression
WARNING_THRESHOLD | VARCHAR2(256) | The value of the warning threshold.
CRITICAL_OPERATOR | NUMBER | Defines the critical threshold condition to be applied 0 - GT 1 - EQ 2 - LT 3 - LE 4 - GE 5 - CONTAINS 6 - NE 7 - MATCH : regular expression
CRITICAL_THRESHOLD | VARCHAR2(256) | The value of the critical threshold.
OCCURRENCE_COUNT | NUMBER | The number of times the test has to trigger to raise a violation.
WARNING_ACTION_TYPE | VARCHAR2(17) | The warning corrective action type configured. Possible values are : No-Action : when no action is configured Corrective-Action : when a repository side corrective action is configured Agent-Fixit Job : when an agent side fix-it job is configured.
WARNING_ACTION_JOB_TYPE | VARCHAR2(32) | Specifies the job type of the warning corrective action when WARNING_ACTION_TYPE is ÒCorrective-ActionÓ.
WARNING_ACTION_JOB_OWNER | VARCHAR2(256) | Specifies the job owner of the warning corrective action when WARNING_ACTION_TYPE is ÒCorrective-ActionÓ.
WARNING_ACTION_JOB_NAME | VARCHAR2(64) | Specifies the job name of the warning corrective action when WARNING_ACTION_TYPE is ÒCorrective-ActionÓ.
CRITICAL_ACTION_TYPE | VARCHAR2(17) | The critical corrective action type configured. Possible values are : No-Action : when no action is configured Corrective-Action : when a repository side corrective action is configured Agent-Fixit Job : when an
CRITICAL_ACTION_JOB_TYPE | VARCHAR2(32) | Specifies the job type of the critical corrective action when CRITICAL_ACTION_TYPE is ÒCorrective-ActionÓ.
CRITICAL_ACTION_JOB_OWNER | VARCHAR2(256) | Specifies the job owner of the critical corrective action when CRITICAL_ACTION_TYPE is ÒCorrective-ActionÓ.
CRITICAL_ACTION_JOB_NAME | VARCHAR2(64) | Specifies the job name of the critical corrective action when CRITICAL_ACTION_TYPE is ÒCorrective-ActionÓ.

## Job Views

### MGMT$JOBS

MGMT$JOBS displays information about a job including the job's schedule.

Table 6-42 MGMT$JOBS

Column | Datatype | Description
--- | --- | ---
JOB_NAME | VARCHAR2(64) | The unique name for the job.
JOB_ID | RAW(16) | The uniqe system identifier for the job.
JOB_OWNER | VARCHAR2(256) | The owner/creator of the job.
JOB_DESCRIPTION | VARCHAR2(4000) | Optional text describing the job function.
JOB_TYPE | VARCHAR2(32) | The job type. For example, multi-task, SQL script or OS Command.
TARGET_TYPE | VARCHAR2() | The type of target the job was submitted against. Applies to single-target jobs only.
IS_LIBRARY | NUMBER(1) | Indicates whether or not the job is part of the job library.
IS_RESTARTABLE | NUMBER(1) | Indicates whether the job can be restarted. Ò0Ó indicates the job is not restartable. Ò1Ó indicates the job is not restartable. By default, a job is not restartable if the original job owner is deleted and the job is transferred to another administrator.
START_TIME | DATE | The scheduled start time. For daily, days of week and days of month schedules, the start_time denotes when the job should start.
END_TIME | DATE | For all periodic schedules, the last date (and time) to run the job. For daily, day of week and day of month schedules, only the date portion is used.
TIMEZONE_TYPE |  | Possible values are 1 - Repository timezone 2- Target timezone 4 - Specified timezone region
TIMEZONE_REGION | VARCHAR2(64) | The specified timezone region.
SCHEDULE_TYPE |  | Possible values are: 0 - Immediate schedule 1 - Run once at specified time 2 - Run on interval 3 - Run daily 4 - Run on specified days of the week 5 - Run on specified days of the month 6 - Run on specified days of the year
INTERVAL | NUMBER | If schedule_type is interval (2) , this is the interval at which the job repeats, in minutes
EXECUTION_HOURS | NUMBER(3) | Indicates the time of day at which the job will execute. Hours are specified using the 24-hour format (0 to 23).
EXECUTION_MINUTES | NUMBER(3) | Indicates the time of day at which the job will execute. Minues are specified as a number between 0 and 59.
MONTHS | Integer Array | For days-of-year job schedules, this indicates the ÒmonthÓ in the schedule.
DAYS | Integer Array | For day-of-week/month or day(s) of the week job schedules, this iindicates the ÒdayÓ of the week/month. Days-of-week specified as numbers 1 (Sunday) to 7 (Saturday). Days-of-month specified as numbers 1 to 31.

### MGMT$JOB_TARGETS

MGMT$JOB_TARGETS displays the target(s) the job was submitted against.

Table 6-43 MGMT$JOB_TARGETS

Column | Datatype | Description
--- | --- | ---
JOB_NAME | VARCHAR2(64) | The unique name for the job.
JOB_OWNER | VARCHAR2(256) | The owner/creator of the job.
JOB_TYPE | VARCHAR2(32) | The job type. For example, multi-task, SQL script or OS Command.
TARGET_NAME | VARCHAR2(64) | Name of the target the job was submitted against.
TARGET_TYPE | VARCHAR2() | The type of target the job was submitted against. Applies to single-target jobs only.
TARGET_GUID | RAW(16) | The unique global identifier for the target.

### MGMT$JOB_EXECUTION_HISTORY

MGMT$JOB_EXECUTION_HISTORY displays a summary of job executions along with their status and targets for each execution.

Table 6-44 MGMT$JOB_EXECUTION_HISTORY

Column | Datatype | Description
--- | --- | ---
JOB_NAME | VARCHAR2(64) | The unique name for the job.
JOB_OWNER | VARCHAR2(256) | The owner/creator of the job.
JOB_ID | RAW(16) | The uniqe system identifier for the job.
JOB_TYPE | VARCHAR2(32) | The job type. For example, multi-task, SQL script or OS Command.
EXECUTION_ID | RAW(16) | The unique execution identifier.
SCHEDULED_TIME | DATE | The scheduled time of job execution.
START_TIME | DATE | The actual time the job executed.
END_TIME | DATE | The actual time the job terminated execution.
STATUS | INTEGER | The current status of the job execution represented by integers 1 to 18: 1: Scheduled 2: Running 3: Failed Initialization 4: Failed 5: Succeeded 6: Suspended by User 7: Suspended: Agent Unreachable 8: Stopped 9: Suspended on Lock 10: Suspended on Event 11: Stop Pending 13: Suspend Pending 14: Inactive 15: Queued 16: Failed Retried 18: Skipped
TARGET_NAME | VARCHAR2(64) | Name of the target the job was submitted against.
TARGET_TYPE | VARCHAR2() | The type of target the job was submitted against. Applies to single-target jobs only.
TARGET_GUID | RAW(16) | The unique global identifier for the target.

### MGMT$JOB_STEP_HISTORY

MGMT$JOB_STEP_HISTORY displays step-level details of job executions.

Table 6-45 MGMT$JOB_STEP_HISTORY

Column | Datatype | Description
--- | --- | ---
JOB_NAME | VARCHAR2(64) | The unique name for the job.
JOB_OWNER | VARCHAR2(256) | The owner/creator of the job.
JOB_ID | RAW(16) | The uniqe system identifier for the job.
JOB_TYPE | VARCHAR2(32) | The job type. For example, multi-task, SQL script or OS Command.
EXECUTION_ID | RAW(16) | The unique execution identifier.
STEP_NAME | VARCHAR2(variable) | The name of the job step.
START_TIME | DATE | The start time of the job step.
END_TIME | DATE | The end time of the job step.
STATUS | INTEGER | The current status of the job execution represented by integers 1 to 18: 1: Scheduled 2: Running 3: Failed Initialization 4: Failed 5: Succeeded 6: Suspended by User 7: Suspended: Agent Unreachable 8: Stopped 9: Suspended on Lock 10: Suspended on Event 11: Stop Pending 13: Suspend Pending 14: Inactive 15: Queued 16: Failed Retried 18: Skipped
TARGET_NAME | VARCHAR2(64) | Name of the target the job was submitted against.
TARGET_TYPE | VARCHAR2() | The type of target the job was submitted against. Applies to single-target jobs only.
TARGET_GUID | RAW(16) | The unique global identifier for the target.
OUTPUT | CLOB | Generated job output.

### MGMT$JOB_ANNOTATIONS

MGMT$JOB_ANNOTATIONS displays a summary of annotations for changes in job status.

Table 6-46 MGMT$JOB_ANNOTATIONS

Column | Datatype | Description
--- | --- | ---
JOB_NAME | VARCHAR2(64) | The unique name for the job.
JOB_OWNER | VARCHAR2(256) | The owner/creator of the job.
JOB_STATUS | NUMBER(2) | The job status. Possible values are as follows: 1: Scheduled 2: Executing 3: Aborted 4: Failed 5: Completed 6: Suspended 7: Agent Down 8: Stopped 9: Suspended/Lock 11: Suspended/Blackout 13: Suspend Pending 15: Queued 16: Failed 17: Waiting 18: Skipped
OCCURRENCE_TIMESTAMP | DATE | The time at which the state change occurred.
ANNOTATION_MESSAGE | VARCHAR2(4000) | Annotation text.
ANNOTATION_TIMESTAMP | DATE | The time the annotation was created.
ANNOTATED_BY | VARCHAR2(256) | Enterprise Manager administrator who authored the the annotation.

### MGMT$JOB_NOTIFICATION_LOG

MGMT$JOB_NOTIFICATION_LOG displays details of notification deliveries for changes in job status.

Table 6-47 MGMT$JOB_NOTIFICATION_LOG

Column | Datatype | Description
--- | --- | ---
JOB_NAME | VARCHAR2(64) | The unique name for the job.
JOB_OWNER | VARCHAR2(256) | The owner/creator of the job.
JOB_STATUS | NUMBER(2) | The job status. Possible values are as follows: 1: Scheduled 2: Executing 3: Aborted 4: Failed 5: Completed 6: Suspended 7: Agent Down 8: Stopped 9: Suspended/Lock 11: Suspended/Blackout 13: Suspend Pending 15: Queued 16: Failed 17: Waiting 18: Skipped
OCCURRENCE_TIMESTAMP | DATE | The time at which the state change occurred.
DELIVERY_MESSAGE | VARCHAR2(1024) | The message indicating the success or failure of the notification delivery.
DELIVERY_TIMESTAMP | DATE | The time at which the log message was created.

## Application Service Level Management Views

### MGMT$CSM_REGION

MGMT$CSM_REGION displays a list of regions and their member targets.

Table 6-48 MGMT$CSM_REGION

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(64) | Name of the target from which the metrics will be collected (Webcache target).
TARGET_TYPE | VARCHAR2(64) | Type defining the set of metrics that are applicable for the target.
REGION_NAME | VARCHAR2(128) | A meaningful name for a logical group (region) containing one or more domains. For example, the REGION_NAME can be a country, company, or company division.
DESCRIPTION | VARCHAR2(256) | A useful description of region.
REGION_MEMBER | VARCHAR2(256) | A member of the region specified by REGION_NAME. REGION_MEMBER can be a domain name or an IP subnet address.
REGION_MEMBER_TYPE | VARCHAR2(16) | Specifies the format type (domain name or IP subnet address) of REGION_ MEMBER. Member type can be specified using "D" for domain or "S" for subnet. For example: REGION_MEMBER=us.oracle MEMBER_ TYPE=D REGION_MEMBER=138.1 MEMBER_ TYPE=S

Usage Notes

List the regions with detailed information.

List the regions of which a target is a member.

List the targets that belong to a region

### MGMT$CSM_WATCHLIST

MGMT$CSM_WATCHLIST displays a list of URLs defined as part of a website target's watchlist. These URLs are periodically visited to monitor the website.

Table 6-49 MGMT$CSM_WATCHLIST

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(64) | Name of the target from which the metrics will be collected (Webcache target).
TARGET_TYPE | VARCHAR2(64) | Type defining the set of metrics that are applicable for the target.
DISPLAY_NAME | VARCHAR2(128) | Display name for the URL.
URL | VARCHAR2(512) | Full URL filename containing the relative path from the web server. (For example, "/somepath/somefile.html").
DESCRIPTION | VARCHAR2(256) | Text description of the URL. (Optional)

Usage Notes

List the URL watchlist for a given target

### MGMT$CSM_METRIC_DETAILS

MGMT$CSM_METRIC_DETAILS displays detailed information on each individual HTTP request for composite targets (for example, a website target) that has one or more Web Cache targets.

Table 6-50 MGMT$CSM_METRIC_DETAILS

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(64) | Name of the target from which the metrics will be collected (Webcache target).
TARGET_TYPE | VARCHAR2(64) | Type defining the set of metrics that are applicable for the target.
COLLECTION_ TIMESTAMP | DATE | The date/time when the metric was collected
METRIC_NAME | VARCHAR2(64) | The name of the metric that is being defined
METRIC_VALUE | NUMBER | Number of milliseconds required to access this URL. This value is the difference in milliseconds between SUBMIT_ACTION_TIMESTAMP and LOAD_ACTION_TIMESTAMP
URL | VARCHAR2(1024) | URL filename relative to the webserver host and port. The response of this url is measured in elapsed_time.
VISITOR_IP | VARCHAR2(32) | IP address of machine making requests
VISITOR_NODE | VARCHAR2(1024) | Resolved machine name from which a logged request is made.
VISITOR_DOMAIN | VARCHAR2(1024) | Domain of the machine making requests.
VISITOR_SUBNET | VARCHAR2(32) | Domain subnet of the machine making the requests.

Usage Notes

Analyze HTTP request patterns over time with regards to visitor information (IP, subnet, domain, region) or URLs (most requested, least requested) for composite targets.

Analyze HTTP request response times over time with regards to visitor information (IP, subnet, domain, region) and URLs for composite targets.

### MGMT$CSM_MT_METRIC_DETAILS

MGMT$CSM_MT_METRIC_DETAILS displays detailed information on each individual HTTP request for Web Cache targets (i.e. member targets). If a Web Cache target is not a member of any composite targets, the composite target columns are presented as NULL. If a Web Cache target is a member of multiple composite targets, a row for each composite target is presented.

Table 6-51 MGMT$CSM_MT_METRIC_DETAILS

Column | Datatype | Description
--- | --- | ---
MEMBER_TARGET_ NAME | VARCHAR2(64) | Name of the Web Cache target.
MEMBER_TARGET_TYPE | VARCHAR2(64) | Type of the Web Cache target.
COMPOSITE_TARGET_ NAME | VARCHAR2(64) | The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. This entry may be null if the Web Cache target is not a member of any composite targets.
COMPOSITE_TARGET_ TYPE | VARCHAR2(64) | The type of the composite target. The type defines the set of metrics that are applicable for the composite target. This entry may be null if the Web Cache target is not a member of any composite targets.
COLLECTION_ TIMESTAMP | DATE | The time when the target status change was last detected and logged in the Management Repository.
METRIC_NAME | VARCHAR2(64) | Name of the metric being defined.
METRIC_VALUE | NUMBER | Number of milliseconds required to access this url. This value is the difference in milliseconds between SUBMIT_ACTION_TIMESTAMP and LOAD_ACTION_TIMESTAMP
URL | VARCHAR2(1024) | URL filename relative to the webserver host and port.
VISITOR_IP | VARCHAR2(32) | IP address of machine making requests
VISITOR_NODE | VARCHAR2(1024) | Resolved machine name from which a logged request is made.
VISITOR_DOMAIN | VARCHAR2(1024) | Domain of the machine making requests.
VISITOR_SUBNET | VARCHAR2(32) | Domain subnet of the machine making the requests.

Usage Notes

Analyze HTTP requests patterns over time with regards to visitor information (IP, subnet, domain, region) or URLs (most requested, least requested) for a particular Web Cache member target of a composite target, or for Web Cache targets that are not a member of any composite targets.

Analyze HTTP request response times over time with regards to visitor information (IP, subnet, domain, region) and URLs for a particular Web Cache member target of a composite target, or for Web Cache targets that are not a member of any composite targets.

### MGMT$CSM_URL_HOURLY

MGMT$CSM_URL_HOURLY displays statistical information about the HTTP requests for a given composite target, aggregated by URL in hourly time periods.

Table 6-52 MGMT$CSM_URL_HOURLY

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(64) | The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. This entry may be null if the Web Cache target is not a member of any composite targets.
TARGET_TYPE | VARCHAR2(64) | The type of the composite target. The type defines the set of metrics that are applicable for the composite target. This entry may be null if the Web Cache target is not a member of any composite targets.
URL | VARCHAR2(1024) | URL filename relative to the webserver host and port.
ROLLUP_TIMESTAMP | DATE | Identifies the start of the rollup period. For the one-hour rollups, samples that fall within the hourly boundaries from minute 00 through minute 59 inclusive will be combined. For example, samples from 12:00 AM through 12:59 AM would be combined into a single aggregated record with a rollup timestamp of "date" 12:00 AM.
METRIC_NAME | VARCHAR2(64) | Name of the metric being defined.
SAMPLE_COUNT | NUMBER | The average of the metric values for the samples that have been included in the rollup period
AVERAGE | NUMBER | The average of the metric values for the samples that have been included in the rollup period
MINIMUM | NUMBER | The minimum value for the metric for the samples that have been included in the rollup period.
MAXIMUM | NUMBER | The maximum value for the metric for samples that have been included in the rollup period.
STANDARD_DEVIATION | NUMBER | The standard deviation for the metric values that have been included in the rollup period.
VARIANCE | NUMBER | The variance for the metric values that has been included in the rollup period

Usage Notes

Analyze hourly HTTP response time patterns and statistical (min, max, avg, stddev) information for a given URL of a composite target. (For example, what was the average response time experienced when accessing URL HTTP://my.oracle.com/home.html of the website my.oracle.com between 8 and 9 this morning).

### MGMT$CSM_URL_DAILY

MGMT$CSM_URL_DAILY displays statistical information about the HTTP requests for a given composite target, aggregated by URL in daily time periods.

Table 6-53 MGMT$CSM_URL_DAILY

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(64) | The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table.
TARGET_TYPE | VARCHAR2(64) | The type of the composite target. The type defines the set of metrics that are applicable for the target.
URL | VARCHAR2(1024) | Full URL filename containing the relative path from the web server. (For example, "/somepath/somefile.html").
ROLLUP_TIMESTAMP | DATE | Identifies the start of the rollup period. For the one-hour rollups, samples that fall within the hourly boundaries from minute 00 through minute 59 inclusive will be combined. For example, samples from 12:00 AM through 12:59 AM would be combined into a single aggregated record with a rollup timestamp of "date" 12:00 AM.
METRIC_NAME | VARCHAR2(64) | Name of the metric being defined.
SAMPLE_COUNT | NUMBER | The average of the metric values for the samples that have been included in the rollup period
AVERAGE | NUMBER | The average of the metric values for the samples that have been included in the rollup period
MINIMUM | NUMBER | The minimum value for the metric for the samples that have been included in the rollup period.
MAXIMUM | NUMBER | The maximum value for the metric for samples that have been included in the rollup period.
STANDARD_DEVIATION | NUMBER | The standard deviation for the metric values that have been included in the rollup period.
VARIANCE | NUMBER | The variance for the metric values that has been included in the rollup period

Usage Notes

Analyze daily HTTP response time patterns and statistical (min, max, avg, stddev) information for a given URL of a composite target. (For example, what was the avg response time experienced when accessing URL HTTP://my.oracle.com/home.html of the website my.oracle.com last Monday).

### MGMT$CSM_URL_DIST_HOURLY

MGMT$CSM_URL_DIST_HOURLY displays the distribution of the HTTP request response times, in seconds, for a URL of a composite target. The data is aggregated in hourly time periods.

Table 6-54 MGMT$CSM_URL_DIST_HOURLY

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(64) | The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table.
TARGET_TYPE | VARCHAR2(64) | The type of the composite target. The type defines the set of metrics that are applicable for the target.
URL | VARCHAR2(1024) | Full URL filename containing the relative path from the web server. (For example, "/somepath/somefile.html").
ROLLUP_TIMESTAMP | DATE | Start of the rollup period (time zone of the target).
METRIC_NAME | VARCHAR2(64) | Name of the metric being defined.
METRIC_VALUE | NUMBER | Number of milliseconds required to access this url. This value is the difference in milliseconds between SUBMIT_ACTION_TIMESTAMP and LOAD_ACTION_TIMESTAMP
SAMPLE_COUNT | NUMBER | The number of non-NULL samples for the metric that were aggregated.

Usage Notes

Analyze the distribution of the HTTP response times for a URL of a composite target during a specific hour of the day (For example, compare the percentage of requests which response time was longer than 5 seconds at 8am and at 5pm).

### MGMT$CSM_URL_DIST_DAILY

MGMT$CSM_URL_DIST_DAILY displays the distribution of the HTTP request response times, in seconds, for a URL of a composite target. The data is aggregated in daily time periods.

Table 6-55 MGMT$CSM_URL_DIST_DAILY

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(64) | The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table.
TARGET_TYPE | VARCHAR2(64) | The type of the composite target. The type defines the set of metrics that are applicable for the target.
URL | VARCHAR2(1024) | Full URL filename containing the relative path from the web server. (For example, "/somepath/somefile.html").
ROLLUP_TIMESTAMP | DATE | Start of the rollup period (time zone of the target).
METRIC_NAME | VARCHAR2(64) | Name of the metric being defined.
METRIC_VALUE | NUMBER | Number of milliseconds required to access this url. This value is the difference in milliseconds between SUBMIT_ACTION_TIMESTAMP and LOAD_ACTION_TIMESTAMP
SAMPLE_COUNT | NUMBER | The number of non-NULL samples for the metric that were aggregated.

Usage Notes

Analyze the distribution of the HTTP response times for a given URL of a composite target during a specific day (For example, compare the percentage of requests which response time was longer than 5 seconds on Monday and on Saturday).

### MGMT$CSM_MT_URL_HOURLY

MGMT$CSM_MT_URL_HOURLY displays statistical information about the HTTP requests for a given Web Cache target of a composite target, aggregated by URL in hourly time periods. If a Web Cache target is not a member of any composite targets, the composite target columns are presented as NULL. If a Web Cache target is a member of multiple composite targets, a row for each composite target is presented.

Table 6-56 MGMT$CSM_MT_URL_HOURLY

Column | Datatype | Description
--- | --- | ---
MEMBER_TARGET_ NAME | VARCHAR2(64) | The Web Cache target.
MEMBER_TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics that are applicable for the target.
COMPOSITE_TARGET_ NAME | VARCHAR2(64) | The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. May be null if the Web Cache target is not a member of any composite targets.
COMPOSITE_TARGET_ TYPE | VARCHAR2(64) | The type of the composite target. The type defines the set of metrics that are applicable for the target. May be null if the Web Cache target is not a member of any composite target.
URL | VARCHAR2(1024) | Full URL filename containing the relative path from the web server. (For example, "/somepath/somefile.html").
ROLLUP_TIMESTAMP | DATE | Start of the rollup period (time zone of the target).
METRIC_NAME | VARCHAR2(64) | Name of the metric being defined.
SAMPLE_COUNT | NUMBER | The number of non-NULL samples for the metric that were aggregated.
AVERAGE | NUMBER | The average of the metric values for the samples that have been included in the rollup period
MINIMUM | NUMBER | The minimum value for the metric for the samples that have been included in the rollup period.
MAXIMUM | NUMBER | The maximum value for the metric for samples that have been included in the rollup period.
STANDARD_DEVIATION | NUMBER | The standard deviation for the metric values that have been included in the rollup period.
VARIANCE | NUMBER | The variance for the metric values that has been included in the rollup period

Usage Notes

Analyze hourly HTTP response time patterns and statistical (min, max, avg, stddev) information for a given URL of a Web Cache target and optionally of a composite target (For example, what was the avg response time experienced when accessing URL HTTP://my.oracle.com/home.html at Web Cache WEB5 of the website my.oracle.com between 8 and 9 this morning).

### MGMT$CSM_MT_URL_DAILY

MGMT$CSM_MT_URL_DAILY displays statistical information about the HTTP requests for a given Web Cache target of a composite target, aggregated by URL in daily time periods. If a Web Cache target is not a member of any composite targets, the composite target columns are presented as NULL. If a Web Cache target is a member of multiple composite targets, a row for each composite target is presented.

Table 6-57 MGMT$CSM_MT_URL_DAILY

Column | Datatype | Description
--- | --- | ---
MEMBER_TARGET_ NAME | VARCHAR2(64) | The Web Cache target.
MEMBER_TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics that are applicable for the target.
COMPOSITE_TARGET_ NAME | VARCHAR2(64) | The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. May be null if the Web Cache target is not a member of any composite targets.
COMPOSITE_TARGET_ TYPE | VARCHAR2(64) | The type of the composite target. The type defines the set of metrics that are applicable for the target. May be null if the Web Cache target is not a member of any composite targets.
URL | VARCHAR2(1024) | Full URL filename containing the relative path from the web server. (For example, "/somepath/somefile.html").
ROLLUP_TIMESTAMP | DATE | Start of the rollup period (time zone of the target).
METRIC_NAME | VARCHAR2(64) | Name of the metric being defined.
SAMPLE_COUNT | NUMBER | The number of non-NULL samples for the metric that were aggregated.
AVERAGE | NUMBER | The average of the metric values for the samples that have been included in the rollup period
MINIMUM | NUMBER | The minimum value for the metric for the samples that have been included in the rollup period.
MAXIMUM | NUMBER | The maximum value for the metric for samples that have been included in the rollup period.
STANDARD_DEVIATION | NUMBER | The standard deviation for the metric values that have been included in the rollup period.
VARIANCE | NUMBER | The variance for the metric values that has been included in the rollup period

Usage Notes

Analyze daily HTTP response time patterns and statistical (min, max, avg, stddev) information for a given URL of a Web Cache target and optionally of a composite target. target (For example, what was the avg response time experienced when accessing URL HTTP://my.oracle.com/home.html at Web Cache WEB5 of the website my.oracle.com last Monday).

### MGMT$CSM_MT_URL_DIST_HOURLY

MGMT$CSM_MT_URL_DIST_HOURLY displays the distribution of the HTTP request response times, in seconds, for a URL of a given Web Cache target of a composite target. The data is aggregated in hourly time periods. If a Web Cache target is not a member of any composite targets, the composite target columns are presented as NULL. If a Web Cache target is a member of multiple composite targets, a row for each composite target is presented.

Table 6-58 MGMT$CSM_MT_URL_DIST_HOURLY

Column | Datatype | Description
--- | --- | ---
MEMBER_TARGET_ NAME | VARCHAR2(64) | The Web Cache target.
MEMBER_TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics that are applicable for the target.
COMPOSITE_TARGET_ NAME | VARCHAR2(64) | The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. May be null if the Web Cache target is not a member of any composite targets.
COMPOSITE_TARGET_ TYPE | VARCHAR2(64) | The type of the composite target. The type defines the set of metrics that are applicable for the target. May be null if the Web Cache target is not a member of any composite targets.
URL | VARCHAR2(1024) | Full URL filename containing the relative path from the web server. (For example, "/somepath/somefile.html").
ROLLUP_TIMESTAMP | DATE | Start of the rollup period (time zone of the target).
METRIC_NAME | VARCHAR2(64) | Name of the metric being defined.
METRIC_VALUE | NUMBER | Number of milliseconds required to access this url. This value is the difference in milliseconds between SUBMIT_ACTION_TIMESTAMP and LOAD_ACTION_TIMESTAMP
SAMPLE_COUNT | NUMBER | The number of non-NULL samples for the metric that were aggregated.

Usage Notes

Analyze the distribution of the HTTP response times for a URL of a Web Cache target of a composite target during a specific hour of the day (For example, how many requests for URL HTTP://my.oracle.com/home.html at Web Cache WEB5 of the website my.oracle.com took longer than 5 seconds between 8 and 9 this morning).

### MGMT$CSM_MT_URL_DIST_DAILY

MGMT$CSM_MT_URL_DIST_DAILY displays the distribution of the HTTP request response times, in seconds, for a URL of a given Web Cache target of a composite target. The data is aggregated in daily time periods. If a Web Cache target is not a member of any composite targets, the composite target columns are presented as NULL. If a Web Cache target is a member of multiple composite targets, a row for each composite target is presented.

Table 6-59 MGMT$CSM_MT_URL_DIST_DAILY

Column | Datatype | Description
--- | --- | ---
MEMBER_TARGET_ NAME | VARCHAR2(64) | The Web Cache target.
MEMBER_TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics that are applicable for the target.
COMPOSITE_TARGET_ NAME | VARCHAR2(64) | The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. May be null if the Web Cache target is not a member of any composite targets.
COMPOSITE_TARGET_ TYPE | VARCHAR2(64) | The type of the composite target. The type defines the set of metrics that are applicable for the target. May be null if the Web Cache target is not a member of any composite targets.
URL | VARCHAR2(1024) | Full URL filename containing the relative path from the web server. (For example, "/somepath/somefile.html").
ROLLUP_TIMESTAMP | DATE | Start of the rollup period (time zone of the target).
METRIC_NAME | VARCHAR2(64) | Name of the metric being defined.
METRIC_VALUE | NUMBER | Number of milliseconds required to access this url. This value is the difference in milliseconds between SUBMIT_ACTION_TIMESTAMP and LOAD_ACTION_TIMESTAMP
SAMPLE_COUNT | NUMBER | The number of non-NULL samples for the metric that were aggregated.

Usage Notes

Analyze the distribution of the HTTP response times for a URL of a Web Cache target of a composite target during a specific day (For example, how many requests for URL HTTP://my.oracle.com/home.html at Web Cache WEB5 of the website my.oracle.com took longer than 5 seconds last Monday).

### MGMT$CSM_IP_HOURLY

MGMT$CSM_IP_HOURLY displays statistical information about the HTTP requests for a given composite target, aggregated by the visitor IP address in hourly time periods.

Table 6-60 MGMT$CSM_IP_HOURLY

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(64) | The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table.
TARGET_TYPE | VARCHAR2(64) | The type of the composite target. The type defines the set of metrics that are applicable for the target.
VISITOR | VARCHAR2(1024) | Node name (if available) or IP address of the requesting target. This may be a gateway or router if one exists between the user machine and the webserver target.
ROLLUP_TIMESTAMP | DATE | Start of the rollup period (time zone of the target).
METRIC_NAME | VARCHAR2(64) | Name of the metric being defined.
SAMPLE_COUNT | NUMBER | The number of non-NULL samples for the metric that were aggregated.
AVERAGE | NUMBER | The average of the metric values for the samples that have been included in the rollup period
MINIMUM | NUMBER | The minimum value for the metric for the samples that have been included in the rollup period.
MAXIMUM | NUMBER | The maximum value for the metric for samples that have been included in the rollup period.
STANDARD_DEVIATION | NUMBER | The standard deviation for the metric values that have been included in the rollup period.
VARIANCE | NUMBER | The variance for the metric values that has been included in the rollup period

Usage Notes

Analyze hourly HTTP response time patterns and statistical (min, max, avg, stddev) information for a given visitor IP address of a composite target (For example, what was the avg response time experienced from IP address 192.168.1.1 when accessing the website my.oracle.com between 8 and 9 this morning).

### MGMT$CSM_IP_DAILY

MGMT$CSM_IP_DAILY displays statistical information about the HTTP requests for a given composite target, aggregated by visitor IP address in daily time periods.

Table 6-61 MGMT$CSM_IP_DAILY

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(64) | The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table.
TARGET_TYPE | VARCHAR2(64) | The type of the composite target. The type defines the set of metrics that are applicable for the target.
VISITOR | VARCHAR2(1024) | Node name (if available) or IP address of the requesting target. This may be a gateway or router if one exists between the user machine and the webserver target.
ROLLUP_TIMESTAMP | DATE | Start of the rollup period (time zone of the target).
METRIC_NAME | VARCHAR2(64) | Name of the metric being defined.
SAMPLE_COUNT | NUMBER | The number of non-NULL samples for the metric that were aggregated.
AVERAGE | NUMBER | The average of the metric values for the samples that have been included in the rollup period
MINIMUM | NUMBER | The minimum value for the metric for the samples that have been included in the rollup period.
MAXIMUM | NUMBER | The maximum value for the metric for samples that have been included in the rollup period.
STANDARD_DEVIATION | NUMBER | The standard deviation for the metric values that have been included in the rollup period.
VARIANCE | NUMBER | The variance for the metric values that has been included in the rollup period

Usage Notes

Analyze daily HTTP response time patterns and statistical (min, max, avg, stddev) information for a given visitor IP address of a composite target (For example, what was the avg response time experienced from IP address 192.168.1.1 when accessing the website my.oracle.com last Monday).

### MGMT$CSM_IP_DIST_HOURLY

MGMT$CSM_IP_DIST_HOURLY displays the distribution of the HTTP request response times, in seconds, for a visitor IP address of a composite target. The data is aggregated in hourly time periods.

Table 6-62 MGMT$CSM_IP_DIST_HOURLY

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(64) | The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table.
TARGET_TYPE | VARCHAR2(64) | The type of the composite target. The type defines the set of metrics that are applicable for the target.
VISITOR | VARCHAR2(1024) | Node name (if available) or IP address of the requesting target. This may be a gateway or router if one exists between the user machine and the webserver target.
ROLLUP_TIMESTAMP | DATE | Start of the rollup period (time zone of the target).
METRIC_NAME | NUMBER | Name of the metric being defined.
METRIC_VALUE | NUMBER | Number of milliseconds required to access this url. This value is the difference in milliseconds between SUBMIT_ACTION_TIMESTAMP and LOAD_ACTION_TIMESTAMP
SAMPLE_COUNT | NUMBER | The number of non-NULL samples for the metric that were aggregated.

Usage Notes

Analyze the distribution of the HTTP response times for a visitor IP address of a composite target during a specific hour of the day (For example, how many requests from IP address 192.168.1.1 to the website my.oracle.com took longer than 5 seconds between 8 and 9 this morning).

### MGMT$CSM_IP_DIST_DAILY

MGMT$CSM_IP_DIST_DAILY displays the distribution of the HTTP request response times, in seconds, for a visitor IP address of a composite target. The data is aggregated in daily time periods.

Table 6-63 MGMT$CSM_IP_DIST_DAILY

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(64) | The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table.
TARGET_TYPE | VARCHAR2(64) | The type of the composite target. The type defines the set of metrics that are applicable for the target.
VISITOR | VARCHAR2(1024) | Node name (if available) or IP address of the requesting target. This may be a gateway or router if one exists between the user machine and the webserver target.
ROLLUP_TIMESTAMP | DATE | Start of the rollup period (time zone of the target).
METRIC_NAME | NUMBER | Name of the metric being defined.
METRIC_VALUE | NUMBER | Number of milliseconds required to access this url. This value is the difference in milliseconds between SUBMIT_ACTION_TIMESTAMP and LOAD_ACTION_TIMESTAMP
SAMPLE_COUNT | NUMBER | The number of non-NULL samples for the metric that were aggregated.

Usage Notes

Analyze the distribution of the HTTP response times for a given visitor IP address of a composite target during a specific day (For example, how many requests from IP address 192.168.1.1 to the website my.oracle.com took longer than 5 seconds last Monday).

### MGMT$CSM_MT_IP_HOURLY

MGMT$CSM_MT_IP_HOURLY displays statistical information about the HTTP requests for a given Web Cache target of a composite target, aggregated by visitor IP address in hourly time periods. If a Web Cache target is not a member of any composite targets, the composite target columns are presented as NULL. If a Web Cache target is a member of multiple composite targets, a row for each composite target is presented.

Table 6-64 MGMT$CSM_MT_IP_HOURLY

Column | Datatype | Description
--- | --- | ---
MEMBER_TARGET_ NAME | VARCHAR2(64) | The Web Cache target.
MEMBER_TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics that are applicable for the target.
COMPOSITE_TARGET_ NAME | VARCHAR2(64) | The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. May be null if the Web Cache target is not a member of any composite targets.
COMPOSITE_TARGET_ TYPE | VARCHAR2(64) | The type of the composite target. The type defines the set of metrics that are applicable for the target. May be null if the Web Cache target is not a member of any composite targets.
VISITOR | VARCHAR2(1024) | Node name (if available) or IP address of the requesting target. This may be a gateway or router if one exists between the user machine and the webserver target.
ROLLUP_TIMESTAMP | DATE | Start of the rollup period (time zone of the target).
METRIC_NAME | VARCHAR2(64) | Name of the metric being defined.
SAMPLE_COUNT | NUMBER | The number of non-NULL samples for the metric that were aggregated.
AVERAGE | NUMBER | The average of the metric values for the samples that have been included in the rollup period
MINIMUM | NUMBER | The minimum value for the metric for the samples that have been included in the rollup period.
MAXIMUM | NUMBER | The maximum value for the metric for samples that have been included in the rollup period.
STANDARD_DEVIATION | NUMBER | The standard deviation for the metric values that have been included in the rollup period.
VARIANCE | NUMBER | The variance for the metric values that has been included in the rollup period

Usage Notes

Analyze hourly HTTP response time patterns and statistical (min, max, avg, stddev) information for a given visitor IP address of a Web Cache target and optionally of a composite target (For example, what was the avg response time experienced from IP address 192.168.1.1 when accessing Web Cache WEB5 of the website my.oracle.com between 8 and 9 this morning).

### MGMT$CSM_MT_IP_DAILY

MGMT$CSM_MT_IP_DAILY displays statistical information about the HTTP requests for a given Web Cache target of a composite target, aggregated by visitor IP address in daily time periods. If a Web Cache target is not a member of any composite targets, the composite target columns are presented as NULL. If a Web Cache target is a member of multiple composite targets, a row for each composite target is presented.

Table 6-65 MGMT$CSM_MT_IP_DAILY

Column | Datatype | Description
--- | --- | ---
MEMBER_TARGET_ NAME | VARCHAR2(64) | The Web Cache target.
MEMBER_TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics that are applicable for the target.
COMPOSITE_TARGET_ NAME | VARCHAR2(64) | The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. May be null if the Web Cache target is not a member of any composite targets.
COMPOSITE_TARGET_ TYPE | VARCHAR2(64) | The type of the composite target. The type defines the set of metrics that are applicable for the target. May be null if the Web Cache target is not a member of any composite targets.
VISITOR | VARCHAR2(1024) | Node name (if available) or IP address of the requesting target. This may be a gateway or router if one exists between the user machine and the webserver target.
ROLLUP_TIMESTAMP | DATE | Start of the rollup period (time zone of the target).
METRIC_NAME | VARCHAR2(64) | Name of the metric being defined.
SAMPLE_COUNT | NUMBER | The number of non-NULL samples for the metric that were aggregated.
AVERAGE | NUMBER | The average of the metric values for the samples that have been included in the rollup period
MINIMUM | NUMBER | The minimum value for the metric for the samples that have been included in the rollup period.
MAXIMUM | NUMBER | The maximum value for the metric for samples that have been included in the rollup period.
STANDARD_DEVIATION | NUMBER | The standard deviation for the metric values that have been included in the rollup period.
VARIANCE | NUMBER | The variance for the metric values that has been included in the rollup period

Usage Notes

Analyze daily HTTP response time patterns and statistical (min, max, avg, stddev) information for a given visitor IP address of a Web Cache target and optionally of a composite target (For example, what was the avg response time experienced from IP address 192.168.1.1 when accessing Web Cache WEB5 of the website my.oracle.com last Monday).

### MGMT$CSM_MT_IP_DIST_HOURLY

MGMT$CSM_MT_IP_DIST_HOURLY displays the distribution of the HTTP request response times, in seconds, for a visitor IP address of a given Web Cache target of a composite target. The data is aggregated in hourly time periods. If a Web Cache target is not a member of any composite targets, the composite target columns are presented as NULL. If a Web Cache target is a member of multiple composite targets, a row for each composite target is presented.

Table 6-66 MGMT$CSM_MT_IP_DIST_HOURLY

Column | Datatype | Description
--- | --- | ---
MEMBER_TARGET_ NAME | VARCHAR2(64) | The Web Cache target.
MEMBER_TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics that are applicable for the target.
COMPOSITE_TARGET_ NAME | VARCHAR2(64) | The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. May be null if the Web Cache target is not a member of any composite targets.
COMPOSITE_TARGET_ TYPE | VARCHAR2(64) | The type of the composite target. The type defines the set of metrics that are applicable for the target. May be null if the Web Cache target is not a member of any composite targets.
VISITOR | VARCHAR2(1024) | Node name (if available) or IP address of the requesting target. This may be a gateway or router if one exists between the user machine and the webserver target.
ROLLUP_TIMESTAMP | DATE | Start of the rollup period (time zone of the target).
METRIC_NAME | VARCHAR2(64) | Name of the metric being defined.
METRIC_VALUE | NUMBER | Number of milliseconds required to access this url. This value is the difference in milliseconds between SUBMIT_ACTION_TIMESTAMP and LOAD_ACTION_TIMESTAMP
SAMPLE_COUNT | NUMBER | The number of non-NULL samples for the metric that were aggregated.

Usage Notes

Analyze the distribution of the HTTP response times for a visitor IP address of a Web Cache target of a composite target during a specific hour of the day (For example, how many requests from IP address 192.168.1.1 to Web Cache WEB5 of the website my.oracle.com took longer than 5 seconds between 8 and 9 this morning).

### MGMT$CSM_MT_IP_DIST_DAILY

MGMT$CSM_MT_IP_DIST_DAILY displays the distribution of the HTTP request response times, in seconds, for a visitor IP address of a given Web Cache target of a composite target. The data is aggregated in daily time periods. If a Web Cache target is not a member of any composite targets, the composite target columns are presented as NULL. If a Web Cache target is a member of multiple composite targets, a row for each composite target is presented.

Table 6-67 MGMT$CSM_MT_IP_DIST_DAILY

Column | Datatype | Description
--- | --- | ---
MEMBER_TARGET_ NAME | VARCHAR2(64) | The Web Cache target.
MEMBER_TARGET_TYPE | VARCHAR2(64) | The target type defines the set of metrics that are applicable for the target.
COMPOSITE_TARGET_ NAME | VARCHAR2(64) | The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table. May be null if the Web Cache target is not a member of any composite targets.
COMPOSITE_TARGET_ TYPE | VARCHAR2(64) | The type of the composite target. The type defines the set of metrics that are applicable for the target. May be null if the Web Cache target is not a member of any composite targets.
VISITOR | VARCHAR2(1024) | Node name (if available) or IP address of the requesting target. This may be a gateway or router if one exists between the user machine and the webserver target.
ROLLUP_TIMESTAMP | DATE | Start of the rollup period (time zone of the target).
METRIC_NAME | VARCHAR2(64) | Name of the metric being defined.
METRIC_VALUE | NUMBER | Number of milliseconds required to access this url. This value is the difference in milliseconds between SUBMIT_ACTION_TIMESTAMP and LOAD_ACTION_TIMESTAMP
SAMPLE_COUNT | NUMBER | The number of non-NULL samples for the metric that were aggregated.

Usage Notes

Analyze the distribution of the HTTP response times for a visitor IP address of a Web Cache target of a composite target during a specific day (For example, how many requests from IP address 192.168.1.1 to Web Cache WEB5 of the website my.oracle.com took longer than 5 seconds last Monday).

### MGMT$CSM_DOMAIN_HOURLY

MGMT$CSM_DOMAIN_HOURLY displays statistical information about the HTTP requests for a given composite target, aggregated by the visitor IP domain in hourly time periods.

Table 6-68 MGMT$CSM_DOMAIN_HOURLY

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(64) | The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table.
TARGET_TYPE | VARCHAR2(64) | The type of the composite target. The type defines the set of metrics that are applicable for the target.
VISITOR_DOMAIN | VARCHAR2(1024) | Domain of the machine making requests.
ROLLUP_TIMESTAMP | DATE | Start of the rollup period (time zone of the target).
METRIC_NAME | VARCHAR2(64) | Name of the metric being defined.
SAMPLE_COUNT | NUMBER | The number of non-NULL samples for the metric that were aggregated.
AVERAGE | NUMBER | The average of the metric values for the samples that have been included in the rollup period
MINIMUM | NUMBER | The minimum value for the metric for the samples that have been included in the rollup period.
MAXIMUM | NUMBER | The maximum value for the metric for samples that have been included in the rollup period.
STANDARD_DEVIATION | NUMBER | The standard deviation for the metric values that have been included in the rollup period.
VARIANCE | NUMBER | The variance for the metric values that has been included in the rollup period

Usage Notes

Analyze hourly HTTP response time patterns and statistical (min, max, avg, stddev) information for a given visitor IP domain of a composite target (For example, what was the avg response time experienced from users of the domain oracle.co.uk when accessing the website my.oracle.com between 8 and 9 this morning).

### MGMT$CSM_DOMAIN_DAILY

MGMT$CSM_DOMAIN_DAILY displays statistical information about the HTTP requests for a given composite target, aggregated by visitor IP domain in daily time periods.

Table 6-69 MGMT$CSM_DOMAIN_DAILY

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(64) | The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table.
TARGET_TYPE | VARCHAR2(64) | The type of the composite target. The type defines the set of metrics that are applicable for the target.
VISITOR_DOMAIN | VARCHAR2(1024) | Domain of the machine making requests.
ROLLUP_TIMESTAMP | DATE | Start of the rollup period (time zone of the target).
METRIC_NAME | VARCHAR2(64) | Name of the metric being defined.
SAMPLE_COUNT | NUMBER | The number of non-NULL samples for the metric that were aggregated.
AVERAGE | NUMBER | The average of the metric values for the samples that have been included in the rollup period
MINIMUM | NUMBER | The minimum value for the metric for the samples that have been included in the rollup period.
MAXIMUM | NUMBER | The maximum value for the metric for samples that have been included in the rollup period.
STANDARD_DEVIATION | NUMBER | The standard deviation for the metric values that have been included in the rollup period.
VARIANCE | NUMBER | The variance for the metric values that has been included in the rollup period

Usage Notes

Analyze daily HTTP response time patterns and statistical (min, max, avg, stddev) information for a given visitor IP domain of a composite target (For example, what was the avg response time experienced from users of the domain oracle.co.uk when accessing the website my.oracle.com last Monday).

### MGMT$CSM_DOMAIN_DIST_HOURLY

MGMT$CSM_DOMAIN_DIST_HOURLY displays the distribution of the HTTP request response times, in seconds, for a visitor IP domain of a composite target. The data is aggregated in hourly time periods.

Table 6-70 MGMT$CSM_DOMAIN_DIST_HOURLY

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(64) | The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table.
TARGET_TYPE | VARCHAR2(64) | The type of the composite target. The type defines the set of metrics that are applicable for the target.
VISITOR_DOMAIN | VARCHAR2(1024) | Domain of the machine making requests.
ROLLUP_TIMESTAMP | DATE | Start of the rollup period (time zone of the target).
METRIC_NAME | VARCHAR2(64) | Name of the metric being defined.
METRIC_VALUE | NUMBER | Number of milliseconds required to access this url. This value is the difference in milliseconds between SUBMIT_ACTION_TIMESTAMP and LOAD_ACTION_TIMESTAMP
SAMPLE_COUNT | NUMBER | The number of non-NULL samples for the metric that were aggregated.

Usage Notes

Analyze the distribution of the HTTP response times for a visitor IP domain of a composite target during a specific hour of the day (For example, how many requests from users of the domain oracle.co.uk to the website my.oracle.com took longer than 5 seconds between 8 and 9 this morning).

### MGMT$CSM_DOMAIN_DIST_DAILY

MGMT$CSM_DOMAIN_DIST_DAILY displays the distribution of the HTTP request response times, in seconds, for a visitor IP domain of a composite target. The data is aggregated in daily time periods.

Table 6-71 MGMT$CSM_DOMAIN_DIST_DAILY

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(64) | The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table.
TARGET_TYPE | VARCHAR2(64) | The type of the composite target. The type defines the set of metrics that are applicable for the target.
VISITOR_DOMAIN | VARCHAR2(1024) | Domain of the machine making requests.
ROLLUP_TIMESTAMP | DATE | Start of the rollup period (time zone of the target).
METRIC_NAME | VARCHAR2(64) | Name of the metric being defined.
METRIC_VALUE | NUMBER | Number of milliseconds required to access this url. This value is the difference in milliseconds between SUBMIT_ACTION_TIMESTAMP and LOAD_ACTION_TIMESTAMP
SAMPLE_COUNT | NUMBER | The number of non-NULL samples for the metric that were aggregated.

Usage Notes

Analyze the distribution of the HTTP response times for a given visitor IP domain of a composite target during a specific day (For example, how many requests from users of the domain oracle.co.uk to the website my.oracle.com took longer than 5 seconds last Monday).

### MGMT$CSM_SUBNET_HOURLY

MGMT$CSM_SUBNET_HOURLY displays statistical information about the HTTP requests for a given composite target, aggregated by the visitor IP subnet in hourly time periods.

Table 6-72 MGMT$CSM_SUBNET_HOURLY

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(64) | The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table.
TARGET_TYPE | VARCHAR2(64) | The type of the composite target. The type defines the set of metrics that are applicable for the target.
VISITOR_SUBNET | VARCHAR2(32) | Domain subnet of the machine making the requests.
ROLLUP_TIMESTAMP | DATE | Start of the rollup period (time zone of the target).
METRIC_NAME | VARCHAR2(64) | Name of the metric being defined.
SAMPLE_COUNT | NUMBER | The number of non-NULL samples for the metric that were aggregated.
AVERAGE | NUMBER | The average of the metric values for the samples that have been included in the rollup period
MINIMUM | NUMBER | The minimum value for the metric for the samples that have been included in the rollup period.
MAXIMUM | NUMBER | The maximum value for the metric for samples that have been included in the rollup period.
STANDARD_DEVIATION | NUMBER | The standard deviation for the metric values that have been included in the rollup period.
VARIANCE | NUMBER | The variance for the metric values that has been included in the rollup period

Usage Notes

Analyze hourly HTTP response time patterns and statistical (min, max, avg, stddev) information for a given visitor IP subnet of a composite target (For example, what was the avg response time experienced from users of the subnet 192.168.1 when accessing the website my.oracle.com between 8 and 9 this morning).

### MGMT$CSM_SUBNET_DAILY

MGMT$CSM_SUBNET_DAILYdisplays statistical information about the HTTP requests for a given composite target, aggregated by visitor IP subnet in daily time periods.

Table 6-73 MGMT$CSM_SUBNET_DAILY

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(64) | The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table.
TARGET_TYPE | VARCHAR2(64) | The type of the composite target. The type defines the set of metrics that are applicable for the target.
VISITOR_SUBNET | VARCHAR2(32) | Domain subnet of the machine making the requests.
ROLLUP_TIMESTAMP | DATE | Start of the rollup period (time zone of the target).
METRIC_NAME | VARCHAR2(64) | Name of the metric being defined.
SAMPLE_COUNT | NUMBER | The number of non-NULL samples for the metric that were aggregated.
AVERAGE | NUMBER | The average of the metric values for the samples that have been included in the rollup period
MINIMUM | NUMBER | The minimum value for the metric for the samples that have been included in the rollup period.
MAXIMUM | NUMBER | The maximum value for the metric for samples that have been included in the rollup period.
STANDARD_DEVIATION | NUMBER | The standard deviation for the metric values that have been included in the rollup period.
VARIANCE | NUMBER | The variance for the metric values that has been included in the rollup period

Usage Notes

Analyze daily HTTP response time patterns and statistical (min, max, avg, stddev) information for a given visitor IP subnet of a composite target (For example, what was the avg response time experienced from users of the subnet 192.168.1 when accessing the website my.oracle.com last Monday).

### MGMT$CSM_SUBNET_DIST_HOURLY

MGMT$CSM_SUBNET_DIST_HOURLY displays the distribution of the HTTP request response times, in seconds, for a visitor IP subnet of a composite target. The data is aggregated in hourly time periods.

Table 6-74 MGMT$CSM_SUBNET_DIST_HOURLY

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(64) | The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table.
TARGET_TYPE | VARCHAR2(64) | The type of the composite target. The type defines the set of metrics that are applicable for the target.
VISITOR_SUBNET | VARCHAR2(32) | Domain subnet of the machine making the requests.
ROLLUP_TIMESTAMP | DATE | Start of the rollup period (time zone of the target).
METRIC_NAME | VARCHAR2(64) | Name of the metric being defined.
METRIC_VALUE | NUMBER | Number of milliseconds required to access this url. This value is the difference in milliseconds between SUBMIT_ACTION_TIMESTAMP and LOAD_ACTION_TIMESTAMP
SAMPLE_COUNT | NUMBER | The number of non-NULL samples for the metric that were aggregated.

Usage Notes

Analyze the distribution of the HTTP response times for a visitor IP subnet of a composite target during a specific hour of the day (For example, how many requests from users of the subnet 192.168.1 to the website my.oracle.com took longer than 5 seconds between 8 and 9 this morning).

### MGMT$CSM_SUBNET_DIST_DAILY

MGMT$CSM_SUBNET_DIST_DAILY displays the distribution of the HTTP request response times, in seconds, for a visitor IP subnet of a composite target. The data is aggregated in daily time periods.

Table 6-75 MGMT$CSM_SUBNET_DIST_DAILY

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(64) | The name of the composite target. A composite target is a grouping of one or more target name and target types from the target table.
TARGET_TYPE | VARCHAR2(64) | The type of the composite target. The type defines the set of metrics that are applicable for the target.
VISITOR_SUBNET | VARCHAR2(32) | Domain subnet of the machine making the requests.
ROLLUP_TIMESTAMP | DATE | Start of the rollup period (time zone of the target).
METRIC_NAME | VARCHAR2(64) | Name of the metric being defined.
METRIC_VALUE | NUMBER | Number of milliseconds required to access this url. This value is the difference in milliseconds between SUBMIT_ACTION_TIMESTAMP and LOAD_ACTION_TIMESTAMP
SAMPLE_COUNT | NUMBER | The number of non-NULL samples for the metric that were aggregated.

Usage Notes

Analyze the distribution of the HTTP response times for a given visitor IP subnet of a composite target during a specific day (For example, how many requests from users of the subnet 192.168.1 to the website my.oracle.com took longer than 5 seconds last Monday).

### MGMT$E2E_1DAY

MGMT$E2E_1DAY displays the E2E data where rollup time spans from 7 days to 31 days.

Table 6-76 MGMT$E2E_1DAY

Column | Datatype | Description
--- | --- | ---
URI | VARCHAR2(2000) | URL for which the end to end trace is sampled
HITS | NUMBER(8) | No of times the uri is hit for before aggregating the sampled data.
TOTAL_HIT_TIME | NUMBER(10) | Total time taken for the uri to respond.
SERVLET_COUNT | NUMBER(8) | No of servlets used for serving the uri
SERVLET_TIME | NUMBER(10) | Total time taken by all servlets for serving the uri.
JSP_COUNT | NUMBER(8) | No of jsps used for sering the uri.
JSP_TIME | NUMBER(10) | Total time taken by all jsps involved in serving the uri.
EJB_COUNT | NUMBER(8) | No of EJB objects involved in serving the uri.
EJB_TIME | NUMBER(10) | Total time taken by the all the EJB objects involved in the serving the uri.
JDBC_TIME | NUMBER(10) | Total JDBC including SQL, PL/SQL times for serving the uri.
TARGET_GUID | RAW(16) | Target GUID of the web application
ROLLUP_TIMESTAMP | DATE | Since each record in the base table, mgmt_e2e_summary_1day, of this view is a rollup of daily data from mgmt_e2e_summary_1hour, this date corresponds to the time when that rollup has happened.

### MGMT$E2E_HOURLY

MGMT$E2E_HOURLY displays E2E data where rollup time spans from 24 hours to last 7 days.

Table 6-77 MGMT$E2E_HOURLY

Column | Datatype | Description
--- | --- | ---
URI | VARCHAR2(2000) | URL for which the end to end trace is sampled
HITS | NUMBER(8) | No of times the uri is hit for before aggregating the sampled data.
TOTAL_HIT_TIME | NUMBER(10) | Total time taken for the uri to respond.
SERVLET_COUNT | NUMBER(8) | No of servlets used for serving the uri
SERVLET_TIME | NUMBER(10) | Total time taken by all servlets for serving the uri.
JSP_COUNT | NUMBER(8) | No of jsps used for sering the uri.
JSP_TIME | NUMBER(10) | Total time taken by all jsps involved in serving the uri.
EJB_COUNT | NUMBER(8) | No of EJB objects involved in serving the uri.
EJB_TIME | NUMBER(10) | Total time taken by the all the EJB objects involved in the serving the uri.
JDBC_TIME | NUMBER(10) | Total JDBC including SQL, PL/SQL times for serving the uri.
TARGET_GUID | RAW(16) | Target GUID of the web application
ROLLUP_TIMESTAMP | DATE | Since each record in the base table, mgmt_e2e_summary_1day, of this view is a rollup of daily data from mgmt_e2e_summary_1hour, this date corresponds to the time when that rollup has happened.

### MGMT$E2E_RAW

MGMT$E2E_RAW displays E2E data where rollup time is less than 24 hours.

Table 6-78 MGMT$E2E_RAW

Column | Datatype | Description
--- | --- | ---
URI | VARCHAR2(2000) | URL for which the end to end trace is sampled
HITS | NUMBER(8) | No of times the uri is hit for before aggregating the sampled data.
TOTAL_HIT_TIME | NUMBER(10) | Total time taken for the uri to respond.
SERVLET_COUNT | NUMBER(8) | No of servlets used for serving the uri
SERVLET_TIME | NUMBER(10) | Total time taken by all servlets for serving the uri.
JSP_COUNT | NUMBER(8) | No of jsps used for sering the uri.
JSP_TIME | NUMBER(10) | Total time taken by all jsps involved in serving the uri.
EJB_COUNT | NUMBER(8) | No of EJB objects involved in serving the uri.
EJB_TIME | NUMBER(10) | Total time taken by the all the EJB objects involved in the serving the uri.
JDBC_TIME | NUMBER(10) | Total JDBC including SQL, PL/SQL times for serving the uri.
TARGET_GUID | RAW(16) | Target GUID of the web application
ROLLUP_TIMESTAMP | DATE | Since each record in the base table, mgmt_e2e_summary_1day, of this view is a rollup of daily data from mgmt_e2e_summary_1hour, this date corresponds to the time when that rollup has happened.

## Configuration Views

### MGMT$DB_TABLESPACES

MGMT$DB_TABLESPACES displays configuration settings for tablespaces. Tablespace settings are collected from the sys.dba_tablespaces, dba_free_space, dba_data_files, dba_temp_files, and v$temp_extent_pool tables..

Table 6-79 MGMT$DB_TABLESPACES

Column | Datatype | Description
--- | --- | ---
HOST | VARCHAR2(256) | Name of the target where the metrics will be collected.
TARGET_NAME | VARCHAR2(256) | Name of the database containing the datafiles.
TARGET_TYPE | VARCHAR2(64) | The type of target, for example, Oracle_ database.
TARGET_GUID | RAW(16) | The unique ID for the database target.
COLLECTION_ TIMESTAMP | DATE | The date and time when the metrics were collected.
TABLESPACE_NAME | VARCHAR2(30) | Name of the tablespace.
CONTENTS | VARCHAR2(9) | Tablespace contents: PERMANENT or TEMPORARY.
STATUS | VARCHAR2(10), | Tablespace status: ONLINE, OFFLINE, or READ ONLY.
EXTENT_MANAGEMENT | VARCHAR2(10), | Extent management tracking: DICTIONARY or LOCAL.
ALLOCATION_TYPE | VARCHAR2(10), | Type of extent allocation in effect for this tablespace.
LOGGING | VARCHAR2(10), | Default logging attribute.
TABLESPACE_SIZE | NUMBER | Current size of the tablespace in bytes.
INITIAL_EXT_SIZE | NUMBER | Default initial extent size
NEXT_EXTENT | NUMBER | Next extent in the sequence.
INCREMENT_BY | NUMBER | Default percent increase for extent size.
MAX_EXTENTS | NUMBER | Default maximum number of extents
TABLESPACE_USED_SIZE | NUMBER | Amount of data (in bytes) contained in the tablespace.
SEGMENT_SPACE_MANAGEMENT | VARCHAR2(6) | Indicates whether the free and used segment space in the tablespace is managed using free lists (MANUAL) or bitmaps (AUTO)
BLOCK_SIZE | NUMBER | Tablespace block size
MIN_EXTENTS | NUMBER | Default minimum number of extents
MIN_EXTLEN | NUMBER | Minimum extent size for this tablespace
BIGFILE | VARCHAR2(3) | Indicates whether the tablespace is a bigfile tablespace (YES) or a smallfile tablespace (NO)

Usage Notes

Obtain control file configuration settings across all managed database targets.

### MGMT$DB_DATAFILES

MGMT$DB_DATAFILES displays the configuration settings for datafiles. The datafile settings are collected from sources such as sys.dba_data_files, v$datafile, sys.dba_free_space, sys.dba_tablespaces, sys.dba_ temp_files, v$tempfile.

Table 6-80 MGMT$DB_DATAFILES

Column | Datatype | Description
--- | --- | ---
HOST | VARCHAR2(256) | Name of the target where the metrics will be collected.
TARGET_NAME | VARCHAR2(256) | Name of the database containing the datafiles.
TARGET_TYPE | VARCHAR2(64) | The type of target, for example, Oracle_ database.
TARGET_GUID | RAW(16) | The unique ID for the database target.
COLLECTION_ TIMESTAMP | DATE | The date and time when the metrics were collected.
FILE_NAME | VARCHAR2(512) | Name of the datafile.
TABLESPACE_NAME | VARCHAR2(30) | Name of the tablespace containing
STATUS | VARCHAR2(10) | Datafile status: ACTIVE or NOT ACTIVE
FILE_SIZE | NUMBER | Size of the datafile
AUTOEXTENSIBLE | VARCHAR2(3) | Autoextensible indicator
INCREMENT_BY | NUMBER | Autoextension increment.
MAX_FILE_SIZE | NUMBER | Maximum file size in bytes
OS_STORAGE_ENTITY | VARCHAR2(512) | OS level storage entity on which the file resides. For regular files it is the name of the filesystem on which the file resides. For character or raw files it is the name of the raw device

### MGMT$DB_CONTROLFILES

MGMT$DB_CONTROLFILES displays the configuration settings for database control files.

Table 6-81 MGMT$DB_CONTROLFILES

Column | Datatype | Description
--- | --- | ---
HOST | VARCHAR2(256) | Name of the target where the metrics will be collected.
TARGET_NAME | VARCHAR2(256) | Name of the database containing the datafiles.
TARGET_TYPE | VARCHAR2(64) | The type of target, for example, Oracle_ database.
TARGET_GUID | RAW(16) | The unique ID for the database target.
COLLECTION_ TIMESTAMP | DATE | The date and time when the metrics were collected.
FILE_NAME | VARCHAR2(512) | Name of the database control file.
STATUS | VARCHAR2(10), | The type of control file: STANDBY - indicates database is in standby mode LOGICAL - indicates the database is a logical standby database (not a physical standby) CLONE - indicates a clone database BACKUP | CREATED - indicates database is being recovered using a backup or created control file. CURRENT - the control file changes to this type following a standby database activate or database open after recovery.
CREATION_DATE | DATE | Control file creation date.
SEQUENCE_NUM | NUMBER | Control file sequence number incremented by control file transactions.
CHANGE_NUM | NUMBER | Last change number in the backup control file. Value is NULL if the control file is not a backup.
MOD_DATE | DATE | Last timestamp in the backup control file. NULL if the control file is not a backup.
OS_STORAGE_ENTITY | VARCHAR2(512) | OS level storage entity on which the file resides. For regular files it is the name of the filesystem on which the file resides. For character or raw files it is the name of the raw device

### MGMT$DB_DBNINSTANCEINFO

MGMT$DB_DBNINSTANCEINFO displays general information about database instance. The instance information is collected from v$database, v$version, v$instance, global_name, database_properties and v$nls_parameters.

Table 6-82 MGMT$DB_DBNINSTANCEINFO

Column | Datatype | Description
--- | --- | ---
HOST_NAME | VARCHAR2(256) | Name of the target host where the metrics will be collected.
TARGET_NAME | VARCHAR2(256) | Name of the database target from which the metrics are collected.
TARGET_TYPE | VARCHAR2(64) | The type of target, for example, Oracle_ database.
TARGET_GUID | RAW(16) | The unique ID for the database target.
COLLECTION_ TIMESTAMP | DATE | The date and time when the metrics were collected.
DATABASE_NAME | VARCHAR2(9) | Name of the database.
GLOBAL_NAME | VARCHAR2(4000) | Global name of the database
BANNER | VARCHAR2(64) | Component name and version number
HOST | VARCHAR2(64) | Name of the host machine.
INSTANCE_NAME | VARCHAR2(16) | Name of the instance.
STARTUP_TIME | DATE | Time when instance was started up.
LOGINS | VARCHAR2(10) | ALLOWED or RESTRICTED
LOG_MODE | VARCHAR2(12) | The archive log mode, either ARCHIVELOG or NOARCHIVELOG.
OPEN_MODE | VARCHAR2(10) | Open mode information.
DEFAULT_TEMP_TABLESPACE | VARCHAR2(30) | Default temporary tablespace name.
CHARACTERSET | VARCHAR2(64) | NLS parameter value for NLS_CHARACTERSET
NATIONAL_CHARACTERSET | VARCHAR2(64) | NLS parameter value for NLS_NCHAR_CHARACTERSET

Usage Notes

Obtain general instance information across all database targets.

### MGMT$DB_FEATUREUSAGE

MGMT$DB_FEATUREUSAGE displays information about database feature usage.

Table 6-83 MGMT$DB_FEATUREUSAGE

Column | Datatype | Description
--- | --- | ---
HOST | VARCHAR2(256) | Name of the host target where the database feature usage information is collected.
DATABASE_NAME | VARCHAR2(256) | Name of the database where the database feature usage information is collected.
INSTANCE_NAME | VARCHAR2(16) | Name of the instance where the database feature usage information is collected.
TARGET_TYPE | VARCHAR2(64) | Either Oracle_database or rac_database.
DBID | NUMBER | A unique number that identifies a database instance.
NAME | VARCHAR2(64) | The feature name.
CURRENTLY_USED | VARCHAR2(5) | TRUE if the feature is currently in use, FALSE if the feature is not in use.
DETECTED_USAGES | NUMBER | The number of times the feature has been used by the database.
FIRST_USAGE_DATE | DATE | The date that the first usage of the feature occurred.
LAST_USAGE_DATE | DATE | The date of the most recent usage of the feature.
VERSION | VARCHAR2(17) | The version number of the database.
LAST_SAMPLE_DATE | DATE | The date that the database was last evaluated for feature usage.
LAST_SAMPLE_PERIOD | NUMBER | The interval between the LAST_ SAMPLE_DATE date and the database feature usage evaluation before that (by default, seven days).
SAMPLE_INTERVAL | NUMBER | The number of seconds between the LAST_SAMPLE_DATE date and the next database feature usage evaluation.
TOTAL_SAMPLES | NUMBER | The total number of database feature usage evaluation samples that have been collected.
AUX_COUNT | NUMBER | For Oracle internal use only.
DESCRIPTION | VARCHAR2(128) | The description of the feature.

Usage Notes

This view can be used to gain an enterprise-wide view of database feature usage across all Oracle databases.

### MGMT$DB_INIT_PARAMS

MGMT$DB_INIT_PARAMS displays initialization parameter settings for the database. Initialization parameter settings are collected from v$parameter.

Table 6-84 MGMT$DB_INIT_PARAMS

Column | Datatype | Description
--- | --- | ---
HOST_NAME | VARCHAR2(256) | Name of the target where the metrics will be collected.
TARGET_NAME | VARCHAR2(256) | Name of the database target from which the metrics are collected.
TARGET_TYPE | VARCHAR2(64) | The type of target, for example, Oracle_ database.
TARGET_GUID | RAW(16) | The unique ID for the database target.
COLLECTION_ TIMESTAMP | DATE | The date and time when the metrics were collected.
NAME | VARCHAR2(64) | Name of the initialization parameter.
ISDEFAULT | VARCHAR2(6) | Indicates whether the parameter value is the default.
VALUE | VARCHAR2(512) | The parameter value.
DATATYPE | VARCHAR2 | The data type that the value string can be mapped to, for example, NUMBER, DATE, or TEXT.'

Usage Notes

Obtain initialization parameter settings across all database targets.

### MGMT$DB_LICENSE

MGMT$DB_LICENSE displays database license configuration settings. Database license configuration settings are collected from v$license.

Table 6-85 MGMT$DB_LICENSE

Column | Datatype | Description
--- | --- | ---
HOST_NAME | VARCHAR2(256) | The name of the host on which the database is running.
TARGET_NAME | VARCHAR2(256) | Name of the database containing the tablespace.
TARGET_TYPE | VARCHAR2(64) | The type of target, for example, Oracle_ database.
TARGET_GUID | RAW(16) | The unique ID for the database target.
COLLECTION_ TIMESTAMP | DATE | The date and time when the metrics were collected.
SESSIONS_MAX | NUMBER | The maximum number of sessions allowed for the database.
SESSIONS_WARNING | NUMBER | The number of sessions which will generate a warning for the database.
SESSIONS_CURRENT | NUMBER | The current number of sessions for the database.
SESSIONS_HIGHWATER | NUMBER | The highest water mark of sessions for the database.
USERS_MAX | NUMBER | The maximum number of users for the database.

Usage Notes

This view can be used to obtain database license configuration settings across all database targets.

### MGMT$DB_REDOLOGS

MGMT$DB_REDOLOGS displays redo log configuration settings for the database. Redo log configuration settings are collected from the v$log and v$logfile tables.

Table 6-86 MGMT$DB_REDOLOGS

Column | Datatype | Description
--- | --- | ---
HOST_NAME | VARCHAR2(256) | Name of the target where the metrics will be collected.
TARGET_NAME | VARCHAR2(256) | Name of the database target from which the metrics are collected.
TARGET_TYPE | VARCHAR2(64) | The type of target, for example, Oracle_ database.
TARGET_GUID | RAW(16) | The unique ID for the database target.
COLLECTION_ TIMESTAMP | DATE | The date and time when the metrics were collected.
GROUP_NUM | NUMBER | Redo log group identifier number.
STATUS | VARCHAR2(16), | og status: UNUSED - The online redo log has never been written to. This is the state of a redo log that was just added, or just after a RESETLOGS, when it is not the current redo log. CURRENT - This is the current redo log. This implies that the redo log is active. The redo log could be open or closed. ACTIVE - The log is active but is not the current log. It is needed for crash recovery. It may be in use for block recovery. It might or might not be archived. CLEARING - The log is being re-created as an empty log after an ALTER DATABASE CLEAR LOGFILE statement. After the log is cleared, the status changes to UNUSED. CLEARING_CURRENT - The current log is being cleared of a closed thread. The log can stay in this status if there is some failure in the switch such as an I/O error writing the new log header. INACTIVE - The log is no longer needed for instance recovery. It may be in use for media recovery. It might or might not be archived.
MEMBERS | NUMBER | Number of members in the log group
FILE_NAME | VARCHAR2(513), | Redo log file (member) name.
ARCHIVED | VARCHAR2(3), | Archive status either YES or NO.
LOGSIZE | NUMBER | Size of the log file in bytes
SEQUENCE_NUM | NUMBER | Log sequence number
FIRST_CHANGE_SCN | NUMBER | Lowest SCN in the log.
OS_STORAGE_ENTITY | VARCHAR2(512) | OS level storage entity on which the file resides. For regular files it is the name of the filesystem on which the file resides. For character or raw files it is the name of the raw device.
THREAD_NUM | NUMBER | Log thread number.

Usage Notes

Obtain redo log group / file configuration settings across all database targets.

### MGMT$DB_ROLLBACK_SEGS

MGMT$DB_ROLLBACK_SEGS displays rollback segments configuration settings for the database. Rollback segments configuration settings are collected from the sys.dba_rollback_segs and v$rollstat tables.

Table 6-87 MGMT$DB_ROLLBACK_SEGS

Column | Datatype | Description
--- | --- | ---
HOST_NAME | VARCHAR2 | Name of the target where the metrics will be collected.
TARGET_NAME | VARCHAR2(256) | Name of the database containing the datafiles.
TARGET_TYPE | VARCHAR2(64) | The type of target, for example, Oracle_ database.
TARGET_GUID | RAW(16) | The unique ID for the database target.
COLLECTION_ TIMESTAMP | DATE | The date and time when the metrics were collected.
ROLLNAME | VARCHAR2(64)) | Name of the rollback segment
STATUS | VARCHAR2(10) | Rollback segment status
TABLESPACE_NAME | VARCHAR2(30) | Name of the tablespace containing the rollback segment.
EXTENTS | NUMBER | Number of extents in rollback segment.
ROLLSIZE | NUMBER | Size in bytes of rollback segment. This values differs by the number of bytes in one database block from the value of the BYTES column of the ALL/DBA/USER_ SEGMENTS views.
INITIAL_SIZE | NUMBER | Initial extent size in bytes.
NEXT_SIZE | NUMBER | Secondary extent size in bytes.
MAXIMUM_EXTENTS | NUMBER | Maximum number of extents.
MINIMUM_EXTENTS | NUMBER | Minimum number of extents.
PCT_INCREASE | NUMBER | Percent increase for extent size.
OPTSIZE | NUMBER | Optimal size for rollback segments.
AVEACTIVE | NUMBER | Current size of active extents averaged over time.
WRAPS | NUMBER | Number of times rollback segment is wrapped.
SHRINKS | NUMBER | Number of times the size of a rollback segment decreases.
AVESHRINK | NUMBER | Average shrink size.
HWMSIZE | NUMBER | High water mark of rollback segment size.

Usage Notes

Obtain rollback segments configuration settings across all database targets.

### MGMT$DB_SGA

MGMT$DB_SGA displays System Global Area (SGA) configuration settings. SGA settings are collected from the v$sga and v$sgastat tables.

Table 6-88 MGMT$DB_SGA

Column | Datatype | Description
--- | --- | ---
HOST_NAME | VARCHAR2(256) | Name of the target where the metrics will be collected.
TARGET_NAME | VARCHAR2(256) | Name of the database containing the datafiles.
TARGET_TYPE | VARCHAR2(64) | The type of target, for example, Oracle_ database.
TARGET_GUID | RAW(16) | The unique ID for the database target
COLLECTION_ TIMESTAMP | DATE | The date and time when the metrics were collected.
SGANAME | VARCHAR2(64) | SGA component name.
SGASIZE | NUMBER | SGA component size in kilobytes or megabytes

Usage Notes

Obtain System Global Area configuration settings across all database targets.

### MGMT$DB_TABLESPACES

MGMT$DB_TABLESPACES displays configuration settings for tablespaces. Tablespace settings are collected from the sys.dba_tablespaces, dba_free_space, dba_data_files, dba_temp_files, and v$temp_extent_pool tables.

Table 6-89 MGMT$DB_TABLESPACES

Column | Datatype | Description
--- | --- | ---
HOST | VARCHAR2(256) | Name of the target where the metrics will be collected.
TARGET_NAME | VARCHAR2(64) | The type of target, for example, Oracle_ database.
TARGET_GUID | RAW(16) | The unique ID for the database target.
COLLECTION_ TIMESTAMP | DATE | The date and time when the metrics were collected.
TABLESPACE_NAME | VARCHAR2(30) | Name of the tablespace.
CONTENTS | VARCHAR2(9) | Tablespace contents: PERMANENT or TEMPORARY.
STATUS | VARCHAR2(10), | Tablespace status: ONLINE, OFFLINE, or READ ONLY.
EXTENT_MANAGEMENT | VARCHAR2(10), | Extent management tracking: DICTIONARY or LOCAL.
ALLOCATION_TYPE | VARCHAR2(10), | Type of extent allocation in effect for this tablespace.
LOGGING | VARCHAR2(10), | Default logging attribute.
TABLESPACE_SIZE | NUMBER | Current size of the tablespace in bytes.
INITIAL_EXT_SIZE | NUMBER | Default initial extent size
INCREMENT_BY | NUMBER | Default percent increase for extent size.
MAX_EXTENTS | NUMBER | Default maximum number of extents

Usage Notes

Obtain tablespace configuration settings across all database targets.

### MGMT$DB_OPTIONS

MGMT$DB_OPTIONS displays whether or not the option is currently LOADED and ACTIVE, or either the option does not exist or is NOT LOADED or INACTIVE. Options settings are collected by checking user name and status in the sys.dba_users and dba_registry tables.

Table 6-90 MGMT$DB_OPTIONS

Column | Datatype | Description
--- | --- | ---
HOST | VARCHAR2(256) | Name of the target where the metrics will be collected.
TARGET_NAME | VARCHAR2(256) | Name of the database containing the datafiles.
TARGET_TYPE | VARCHAR2(64) | The type of target, for example, Oracle_ database.
TARGET_GUID | RAW(16) | The unique ID for the database target.
COLLECTION_ TIMESTAMP | DATE | The date and time when the metrics were collected.
NAME | VARCHAR2(30) | Name of the database option.
SELECTED | VARCHAR2(5) | If the option is currently LOADED and ACTIVE (TRUE), or either the option does not exist or is NOT LOADED or INACTIVE (FALSE)

Usage Notes

Obtain tablespace configuration settings across all database targets.

## Oracle Home Patching Views

### MGMT$EM_HOMES_PLATFORM

MGMT$EM_HOMES_PLATFORM displays the platform information about the Homes. If the home does not have an ARU platform id, then the platform of the Operating System is considered as the Platform of the home.

Table 6-91 MGMT$EM_HOMES_PLATFORM

Column | Datatype | Description
--- | --- | ---
HOME_ID | RAW(16) | Unique id for home
PLATFORM_ID | NUMBER(10) | If the home has an ARU platform it is used, else the platform id of the host is picked
PLATFORM | VARCHAR2(1024) | The platform corresponding to the platform_id

### MGMT$HOMES_AFFECTED

MGMT$HOMES_AFFECTED displays the list of homes, vulnerable to bugs, which are fixed by the critical patches released. The number of alerts which are applicable to the home are calculated.

Table 6-92 MGMT$HOMES_AFFECTED

Column | Datatype | Description
--- | --- | ---
HOST | VARCHAR2(1024)) | Host name
HOME_DIRECTORY | VARCHAR2(1024) | Home directory location
TARGET_GUID | RAW(16) | Unique id for target
ALERTS | NUMBER | Number of alerts for this home

### MGMT$APPL_PATCH_AND_PATCHSET

MGMT$APPL_PATCH_AND_PATCHSET displays the list of interim patches and patchsets that are applicable to the Homes.

Table 6-93 MGMT$APPL_PATCH_AND_PATCHSET

Column | Datatype | Description
--- | --- | ---
PATCH_ID | NUMBER | The patch Id
TYPE | VARCHAR2(32) | Patch/Patchset
PRODUCT | VARCHAR2(50) | The product on pertaining to the patch.
PATCH_RELEASE | VARCHAR2(30) | Release version.
PLATFORM | VARCHAR2(40) | Platform on which patch is applicable
ADVISORY | VARCHAR2(256) | The alert name.
HOST_NAME | VARCHAR2(256) | Host name
HOME_LOCATION | VARCHAR2(128) | Home directory location.
PATCH_GUID | RAW(16) | Unique id for the patch/patchset.
TARGET_GUID | RAW(16) | Unique id for target.

### MGMT$APPLIED_PATCHES

MGMT$APPLIED_PATCHES displays the list of patches that have been applied on the homes along with the installation time. Each patch can fix more than one bug. The bugs are listed in a comma-separated string.

Table 6-94 MGMT$APPLIED_PATCHES

Column | Datatype | Description
--- | --- | ---
PATCH | VARCHAR2(128) | Patch name.
BUGS | VARCHAR2(256) | The bugs fixed by this patch.
INSTALLATION_TIME | DATE | Time of Installation. Timezone of the target.
HOST | VARCHAR2(256) | Host name.
HOME_LOCATION | VARCHAR2(128) | Home location.
HOME_NAME | VARCHAR2(64) | Name of the home.
CONTAINER_GUID | RAW(16) | Name of the home.
TARGET_GUID | RAW(16) | Unique id for target.

### MGMT$APPLIED_PATCHSETS

MGMT$APPLIED_PATCHSETS displays the list of patchsets that have been applied on the Homes along with the installation time.

Table 6-95 MGMT$APPLIED_PATCHSETS

Column | Datatype | Description
--- | --- | ---
VERSION | VARCHAR2(64) | The version to which the home will get upgraded to when this patchset is applied
NAME | VARCHAR2(128) | Patchset external name
TIMESTAMP | DATE | Time of Installation.Timezone of the target
HOST | VARCHAR2(256) | Host name.
HOME_LOCATION | VARCHAR2(128) | Home location.
HOME_NAME | VARCHAR2(64) | Name of the home.
CONTAINER_GUID | RAW(16) | Name of the home.
TARGET_GUID | RAW(16) | Unique id for target.

## Linux Patching Views

### MGMT$HOSTPATCH_HOSTS

MGMT$HOSTPATCH_HOSTS displays information required to generate compliance reports.

Table 6-96 MGMT$HOSTPATCH_HOSTS

Column | Datatype | Description
--- | --- | ---
HOST_NAME | VARCHAR2(256) | Host name
GROUP_NAME | VARCHAR2(256) | The group the host belongs to.
OUT_OF_DATE_PACKAGES | NUMBER(6) | Number of Packages which have a newer version available
ROGUE_PACKAGES | NUMBER(6) | The packages that are not supposed to be installed on the host

### MGMT$HOSTPATCH_GROUPS

MGMT$HOSTPATCH_GROUPS displays additional information about a group, the maturity level which is set by the administrator and the packages which need the host to be rebooted on application.

Table 6-97 MGMT$HOSTPATCH_GROUPS

Column | Datatype | Description
--- | --- | ---
GROUP_NAME | VARCHAR2(256) | The (unique) name of the Group
MATURITY_LEVEL | VARCHAR2(32) | The maturity level of the group. This is set by the administrator.
NEED_REBOOT_PKGS | VARCHAR2(256) | Comma seperated list of packages which need the machine to be rebooted on application

### MGMT$HOSTPATCH_GRP_COMPL_HIST

MGMT$HOSTPATCH_GRP_COMPL_HIST displays information required to generate compliance history reports.

Table 6-98 MGMT$HOSTPATCH_GRP_COMPL_HIST

Column | Datatype | Description
--- | --- | ---
GROUP_NAME | VARCHAR2(256) | Name of the Group
TOTAL_HOSTS | NUMBER(6) | Number of hosts in the Group
COMPLIANT_HOSTS | NUMBER(6) | Number of compliant Hosts in the Group.
LAST_CHECKED_ON | DATE | Date on which this record was collected.

### MGMT$HOSTPATCH_HOST_COMPL

MGMT$HOSTPATCH_HOST_COMPL displays information required to generate advisory reports.

Table 6-99 MGMT$HOSTPATCH_HOST_COMPL

Column | Datatype | Description
--- | --- | ---
HOST_NAME | VARCHAR2(256) | Host name
PKG_NAME | VARCHAR2(256) | Package name
VERSION | VARCHAR2(64) | Version of the package
IS_OUT_OF_DATE | NUMBER(1) | If out of date
IS_ROGUE | NUMBER(1) | If it is rogue

## Security Views

### MGMT$ESA_ALL_PRIVS_REPORT

MGMT$ESA_ALL_PRIVS_REPORT displays a table containing users and roles that have the 'GRANT ANY' privilege in database security reports.

Table 6-100 MGMT$ESA_ALL_PRIVS_REPORT

Column | Datatype | Description
--- | --- | ---
TARGET_GUID | RAW(16) | The GUID of the target for which the report has the data
TARGET_NAME | VARCHAR2(256) | The name of the target for which the report has the data
PRINCIPAL | VARCHAR2(512) | The user or role which has been granted a privilege which amounts to all privileges on the database.
OBJECT_NAME | VARCHAR2(512) | The privilege (GRANT ANY PRIVILEGE) if granted directly, or the role through it has been granted.

### MGMT$ESA_ANY_DICT_REPORT

MGMT$ESA_ANY_DICT_REPORT displays a table and a chart containing users and roles with access to any dictionary in database security reports.

Table 6-101 MGMT$ESA_ANY_DICT_REPORT

Column | Datatype | Description
--- | --- | ---
TARGET_GUID | RAW(16) | The GUID of the target for which the report has the data.
TARGET_NAME | VARCHAR2(256) | The name of the target for which the report has the data.
PRINCIPAL | VARCHAR2(512) | The user or role which has been granted a privilege which provides it access to any dictionary in the database.
OBJECT_NAME | VARCHAR2(512) | The privilege if granted directly, or the role through it has been granted.

### MGMT$ESA_ANY_PRIV_REPORT

MGMT$ESA_ANY_PRIV_REPORT displays a table and a chart containing users with 'ANY' in some privilege granted to them in database security reports.

Table 6-102 MGMT$ESA_ANY_PRIV_REPORT

Column | Datatype | Description
--- | --- | ---
TARGET_GUID | RAW(16) | The GUID of the target for which the report has the data.
TARGET_NAME | VARCHAR2(256) | The name of the target for which the report has the data.
PRINCIPAL | VARCHAR2(512) | The user or role which has been granted a privilege having 'ANY'
OBJECT_NAME | VARCHAR2(512) | The privilege if granted directly, or the role through it has been granted.

### MGMT$ESA_AUDIT_SYSTEM_REPORT

MGMT$ESA_AUDIT_SYSTEM_REPORT displays a table containing users and roles with the 'AUDIT SYSTEM' privilege in database security reports.

Table 6-103 MGMT$ESA_AUDIT_SYSTEM_REPORT

Column | Datatype | Description
--- | --- | ---
TARGET_GUID | RAW(16) | The GUID of the target for whichthe report has the data
TARGET_NAME | VARCHAR2(256) | The name of the target for which the report has the data.
PRINCIPAL | VARCHAR2(512) | The user or role which has been granted 'AUDIT SYSTEM' privilege.
OBJECT_NAME | VARCHAR2(512) | The privilege if granted directly, or the role through it has been granted.

### MGMT$ESA_BECOME_USER_REPORT

MGMT$ESA_BECOME_USER_REPORT displays a table containing users and roles with the 'BECOME USER' privilege in database security reports.

Table 6-104 MGMT$ESA_BECOME_USER_REPORT

Column | Datatype | Description
--- | --- | ---
TARGET_GUID | RAW(16) | The GUID of the target for which the report has the data
TARGET_NAME | VARCHAR2(256) | The name of the target for which the report has the data
PRINCIPAL | VARCHAR2(512) | The user or role which has been granted 'BECOME USER' privilege.
OBJECT_NAME | VARCHAR2(512) | The privilege if granted directly, or the role through it has been granted.

### MGMT$ESA_CATALOG_REPORT

MGMT$ESA_CATALOG_REPORT displays a table and a chart containing all the users that have a role such as '%CATALOG%' in database security reports.

Table 6-105 MGMT$ESA_CATALOG_REPORT

Column | Datatype | Description
--- | --- | ---
TARGET_GUID | RAW(16) | The GUID of the target for which the report has the data.
TARGET_NAME | VARCHAR2(256) | The name of the target for which the report has the data.
PRINCIPAL | VARCHAR2(512) | The user or role which has been granted a role like '%CATALOG%'
OBJECT_NAME | VARCHAR2(512) | The role if granted directly, or the role through it has been granted.

### MGMT$ESA_CONN_PRIV_REPORT

MGMT$ESA_CONN_PRIV_REPORT displays a table and a chart containing users and roles with the CONNECT or RESOURCE role in database security reports.

Table 6-106 MGMT$ESA_CONN_PRIV_REPORT

Column | Datatype | Description
--- | --- | ---
TARGET_GUID | RAW(16) | The GUID of the target for which the report has the data.
TARGET_NAME | VARCHAR2(256) | The name of the target for which the report has the data.
PRINCIPAL | VARCHAR2(512) | The user or role which has been granted the CONNECT or RESOURCE role.
OBJECT_NAME | VARCHAR2(512) | The role if granted directly, or the role through it has been granted.

### MGMT$ESA_CREATE_PRIV_REPORT

MGMT$ESA_CREATE_PRIV_REPORT displays a table and a chart containing users and roles with the CREATE privilege in database security reports.

Table 6-107 MGMT$ESA_CREATE_PRIV_REPORT

Column | Datatype | Description
--- | --- | ---
TARGET_GUID | RAW(16) | The GUID of the target for which the report has the data.
TARGET_NAME | VARCHAR2(256) | The name of the target for which the report has the data.
PRINCIPAL | VARCHAR2(512) | The user or role which has been granted the privilege to create an object in the database.
OBJECT_NAME | VARCHAR2(512) | The role if granted directly, or the role through it has been granted.

### MGMT$ESA_DBA_GROUP_REPORT

MGMT$ESA_DBA_GROUP_REPORT displays a table containing members of the operating system user group DBA in database security reports.

Table 6-108 MGMT$ESA_DBA_GROUP_REPORT

Column | Datatype | Description
--- | --- | ---
TARGET_GUID | RAW(16) | The GUID of the target for which the report has the data.
TARGET_NAME | VARCHAR2(256) | The name of the target for which the report has the data.
PRINCIPAL | VARCHAR2(512) | The operating system user which is in the user group DBA.
OBJECT_NAME | VARCHAR2(512) | DBA Group

### MGMT$ESA_DBA_ROLE_REPORT

MGMT$ESA_DBA_ROLE_REPORT displays a table containing users and roles with the DBA role granted to them in database security reports.

Table 6-109 MGMT$ESA_DBA_ROLE_REPORT

Column | Datatype | Description
--- | --- | ---
TARGET_GUID | RAW(16) | The GUID of the target for which the report has the data.
TARGET_NAME | VARCHAR2(256) | The name of the target for which the report has the data.
PRINCIPAL | VARCHAR2(512) | The user or role which has been granted the DBA Role.
OBJECT_NAME | VARCHAR2(512) | The role if granted directly, or the role through it has been granted.

### MGMT$ESA_DIRECT_PRIV_REPORT

MGMT$ESA_DIRECT_PRIV_REPORT displays a table and a chart containing privileges granted directly in database security reports.

Table 6-110 MGMT$ESA_DIRECT_PRIV_REPORT

Column | Datatype | Description
--- | --- | ---
TARGET_GUID | RAW(16) | The GUID of the target for which the report has the data.
TARGET_NAME | VARCHAR2(256) | The name of the target for which the report has the data.
PRINCIPAL | VARCHAR2(512) | User which has been granted a privilege directly i.e. not via a role.
OBJECT_NAME | VARCHAR2(512) | The privilege that has been granted directly..

### MGMT$ESA_EXMPT_ACCESS_REPORT

MGMT$ESA_EXMPT_ACCESS_REPORT displays a table containing users and roles with the EXEMPT ACCESS POLICY privilege in database security reports.

Table 6-111 MGMT$ESA_EXMPT_ACCESS_REPORT

Column | Datatype | Description
--- | --- | ---
TARGET_GUID | RAW(16) | The GUID of the target for which the report has the data.
TARGET_NAME | VARCHAR2(256) | The name of the target for which the report has the data.
PRINCIPAL | VARCHAR2(512) | The user or role which has been granted the 'EXEMPT ACCESS POLICY' privilege.
OBJECT_NAME | VARCHAR2(512) | The privilege if granted directly, or the role through it has been granted.

### MGMT$ESA_KEY_OBJECTS_REPORT

MGMT$ESA_KEY_OBJECTS_REPORT displays a table and a chart containing users and roles with access to key objects in database security reports.

Table 6-112 MGMT$ESA_KEY_OBJECTS_REPORT

Column | Datatype | Description
--- | --- | ---
TARGET_GUID | RAW(16) | The GUID of the target for which the report has the data.
TARGET_NAME | VARCHAR2(256) | The name of the target for which the report has the data.
USER | VARCHAR2(512) | The user which has access to key objects.
OBJECT_NAME | VARCHAR2(23) | The key object to which that use has access.
PRIVILEGE | VARCHAR2(512) | The privilege on the key object that has been granted to the user.

### MGMT$ESA_OH_OWNERSHIP_REPORT

MGMT$ESA_OH_OWNERSHIP_REPORT displays a table containing file ownership by Oracle Home in database security reports.

Table 6-113 MGMT$ESA_OH_OWNERSHIP_REPORT

Column | Datatype | Description
--- | --- | ---
TARGET_GUID | RAW(16) | The GUID of the target for which the report has the data.
TARGET_NAME | VARCHAR2(256) | The name of the target for which the report has the data.
PRINCIPAL | VARCHAR2(512) | The file whose owner is not the ORACLE HOME owner.
OBJECT_NAME | VARCHAR2(512) | The owner of the file.

### MGMT$ESA_OH_PERMISSION_REPORT

MGMT$ESA_OH_PERMISSION_REPORT displays a table containing file permissions by Oracle Home in database security reports.

Table 6-114 MGMT$ESA_OH_PERMISSION_REPORT

Column | Datatype | Description
--- | --- | ---
TARGET_GUID | RAW(16) | The GUID of the target for which the report has the data.
TARGET_NAME | VARCHAR2(256) | The name of the target for which the report has the data.
PRINCIPAL | VARCHAR2(512) | The file that has an insecure permission.
OBJECT_NAME | VARCHAR2(512) | The permission of the file.

### MGMT$ESA_POWER_PRIV_REPORT

MGMT$ESA_POWER_PRIV_REPORT displays a table and a chart containing all the users and roles with ALTER SESSION, ALTER SYSTEM, CREATE PROCEDURE or CREATE LIBRARY privileges in database security reports.

Table 6-115 MGMT$ESA_POWER_PRIV_REPORT

Column | Datatype | Description
--- | --- | ---
TARGET_GUID | RAW(16) | The GUID of the target for which the report has the data.
TARGET_NAME | VARCHAR2(256) | The name of the target for which the report has the data.
PRINCIPAL | VARCHAR2(512) | The user that has powerful privileges.
OBJECT_NAME | VARCHAR2(512) | The powerful privilege held by the user.

### MGMT$ESA_PUB_PRIV_REPORT

MGMT$ESA_PUB_PRIV_REPORT displays a table and a chart containing privileges granted to PUBLIC in database security reports.

Table 6-116 MGMT$ESA_PUB_PRIV_REPORT

Column | Datatype | Description
--- | --- | ---
TARGET_GUID | RAW(16) | The GUID of the target for which the report has the data.
TARGET_NAME | VARCHAR2(256) | The name of the target for which the report has the data.
PRINCIPAL | VARCHAR2(512) | The object on which some privilege has been granted to PUBLIC.
OBJECT_NAME | VARCHAR2(512) | The privilege on the object which has been granted to PUBLIC.

### MGMT$ESA_SYS_PUB_PKG_REPORT

MGMT$ESA_SYS_PUB_PKG_REPORT displays a table containing system packages with public execute privileges in database security reports.

Table 6-117 MGMT$ESA_SYS_PUB_PKG_REPORT

Column | Datatype | Description
--- | --- | ---
TARGET_GUID | RAW(16) | The GUID of the target for which the report has the data.
TARGET_NAME | VARCHAR2(256) | The name of the target for which the report has the data.
PRINCIPAL | VARCHAR2(512) | PUBLIC
OBJECT_NAME | VARCHAR2(512) | The package owned by SYS on which PUBLIC has execute privileges.

### MGMT$ESA_TABSP_OWNERS_REPORT

MGMT$ESA_TABSP_OWNERS_REPORT displays a table containing tablespaces and their owners in database security reports.

Table 6-118 MGMT$ESA_TABSP_OWNERS_REPORT

Column | Datatype | Description
--- | --- | ---
TARGET_GUID | RAW(16) | The GUID of the target for which the report has the data.
TARGET_NAME | VARCHAR2(256) | The name of the target for which the report has the data.
PRINCIPAL | VARCHAR2(512) | The tablespace.
OBJECT_NAME | VARCHAR2(512) | The owner of the tablespace.

### MGMT$ESA_TRC_AUD_PERM_REPORT

MGMT$ESA_TRC_AUD_PERM_REPORT displays a table containing trace and audit files permissions in database security reports.

Table 6-119 MGMT$ESA_TRC_AUD_PERM_REPORT

Column | Datatype | Description
--- | --- | ---
TARGET_GUID | RAW(16) | The GUID of the target for which the report has the data.
TARGET_NAME | VARCHAR2(256) | The name of the target for which the report has the data.
PRINCIPAL | VARCHAR2(512) | The file path.
OBJECT_NAME | VARCHAR2(512) | The purpose of the file.
PERMISSION | VARCHAR2(512) | Permission of the file.

### MGMT$ESA_WITH_ADMIN_REPORT

MGMT$ESA_WITH_ADMIN_REPORT displays a table and a chart containing users and roles having some privileges granted to them with the WITH ADMIN option in database security reports.

Table 6-120 MGMT$ESA_WITH_ADMIN_REPORT

Column | Datatype | Description
--- | --- | ---
TARGET_GUID | RAW(16) | The GUID of the target for which the report has the data.
TARGET_NAME | VARCHAR2(256) | The name of the target for which the report has the data.
PRINCIPAL | VARCHAR2(512) | The user or role which has been granted a privilege 'WITH ADMIN' option.
OBJECT_NAME | VARCHAR2(512) | The privilege which has been granted 'WITH ADMIN' option.

### MGMT$ESA_WITH_GRANT_REPORT

MGMT$ESA_WITH_GRANT_REPORT displays a table and a chart containing users and roles having some privileges granted to them with 'WITH GRANT' option in database security reports.

Table 6-121 MGMT$ESA_WITH_GRANT_REPORT

Column | Datatype | Description
--- | --- | ---
TARGET_GUID | RAW(16) | The GUID of the target for which the report has the data.
TARGET_NAME | VARCHAR2(256) | The name of the target for which the report has the data.
PRINCIPAL | VARCHAR2(512) | The user or role which has been granted a privilege 'WITH GRANT' option.
OBJECT_NAME | VARCHAR2(512) | The privilege which has been granted 'WITH GRANT' option.

## Configuration Management Views

### MGMT$CSA_COLLECTIONS

MGMT$CSA_COLLECTIONS displays top-level information about all client configurations.

Table 6-122 MGMT$CSA_COLLECTIONS

Column | Datatype | Description
--- | --- | ---
DISPLAY_TARGET_NAME | VARCHAR2(256) | The display name of the client
CSACLIENT | VARCHAR2(4000) | The display name plus the custom keys, if they exist
COLLECTION_TIMESTAMP | DATE | The time at which the data was collected from the client
NET_IP | VARCHAR2(20) | The actual IP address of the client.
NET_EFFECTIVE_IP | VARCHAR2(20) | The client IP address seen by the server
COLLECTION_MESSAGE | VARCHAR2(4000) | Error message generated while applet was running
OS_USER_NAME | VARCHAR2(500) | The client's OS username.
HOSTNAME | VARCHAR2(128) | The client's hostname.
DOMAIN | VARCHAR2(500) | The client's domain.
BOOT_DISK_VOLUME_SERIAL_NUM | VARCHAR2(629) | The client's boot disk volume serial number
COMPLIANCE | NUMBER | The overall compliance score for the client (15=passed, 18=info, 20=warning, 25=critical)
APPID | VARCHAR2(128) | The collection tag for this client configuration
NET_SUBNET | VARCHAR2(20) | The client's subnet mask
NET_LATENCY_IN_MS | NUMBER | The client's HTTP response time with the server
NET_BANDWIDTH_IN_KBITPS | NUMBER | The client's download bandwidth from the server
BROWSER_TYPE | VARCHAR2(100) | The name of the browser used to run CSA
BROWSER_VERSION | VARCHAR2(20) | The version of the browser used to run CSA
BROWSER | VARCHAR2(121) | A summary column that combines the browser name and version
BROWSER_JVM_VENDOR | VARCHAR2(20) | The version of the JVM used to run the applet
BROWSER_JVM_VERSION | VARCHAR2(20) | The version of the JVM used to run the applet
BROWSER_PROXY_SERVER | VARCHAR2(4000) | The proxy server used by the browser
BROWSER_PROXY_EXCEPTIONS | VARCHAR2(4000) | The client's browser proxy exceptions
BROWSER_CACHE_SIZE_IN_MB | NUMBER | The client browser's disk cache size
BROWSER_CACHE_UPATE_FRQ | VARCAHR2(200) | The browser's cache update policy
BROWSER_HTTP1_1_SUPPORT | VARCHAR2(1) | Whether or not the browser supports HTTP 1.1
REFERRING_URL_HEADER | VARCHAR2(4000) | The URL from which the user came to CSA, minus the query string
REFERRING_URL_PARAMS | VARCHAR2(4000) | The query string of the URL from which the user came to CSA
REFURL | VARCHAR2(4000) | The complete URL from which the user came to CSA
CSA_URL_HEADER | VARCHAR2(4000) | The URL from which the user ran CSA, minus the query string
CSA_URL_PARAMS | VARCHAR2(4000) | The query string of the URL from which the user ran CSA
CSAURL | VARCHAR2(4000) | The complete URL from which the user ran CSA
DESTINAION_URL_HEADER | VARCHAR2(4000) | The destination URL, minus the query string
DESTINATION_URL_PARAMS | VARCHAR2(4000) | The query string of the destination URL
DESTURL | VARCHAR2(4000) | The complete destination URL
CONNECTION_TYPE | NUMBER | The estimated connection type, based on the download bandwidth (1=LAN, 2=cable, 3=dialup)
IS_WINDOWS_ADMIN | VARCHAR2(1) | Whether or not the os user is a windows admin
WINDOWS_DOMAIN | VARCHAR2(100) | The windows domain of the host
BROWSER_PROXY_ENABLED | VARCHAR2(1) | Whether or not the proxy server is enabled in the browser
AUTO_CONFIG_URL | VARCHAR2(4000) | The URL of the proxy auto-configuration script used by the browser
NUMBER_OF_COOKIES | NUMBER | The number of cookies collected by CSA
NUMBER_OF_CUSTOM_VALUES | NUMBER | The number of custom properties collected by CSA
HARDWARE | VARCHAR2(4000) | A summary of the system configuration, machine architecture, memory, disk space, and CPU
HARDWARE_VENDOR_NAME | VARCHAR2(128) | The name of the hardware vendor, e.g. ìDellî
SYSTEM_CONFIG | VARCHAR2(4000) | The client's system configuration
MACHINE_ARCHITECTURE | VARCHAR2(500) | The client's machine architecture
BUS_FREQ_IN_MHZ | NUMBER | The frequency of the motherboard's FSB
MEMORY_SIZE_IN_MB | NUMBER | The total amount of physical memory
AVAIL_MEMORY_SIZE_IN_MB | NUMBER | The amount of available physical memory when CSA was run
LOCAL_DISK_SPACE_IN_GB | NUMBER | The total amount of disk space
AVAIL_LOCAL_DISK_SPACE_IN_GB | NUMBER | The available disk space
CPU_COUNT | NUMBER(8) | The number of CPUs
SYSTEM_SERIAL_NUMBER | VARCAHR2(100) | The host's serial number
MIN_CPU_SPEED_IN_MHZ | NUMBER | The minimum possible CPU speed
MAX_CPU_SPEED_IN_MHZ | NUMBER | The maximum possible CPU speed
CPU | VARCHAR2(673) | The CPU vendor, implementation, and frequency
CPU_BOARD_COUNT | NUMBER(8) | The number of CPU boards
IOCARD_COUNT | NUMBER(8) | The number of IO cards
NIC_COUNT | NUMBER | The number of NICs
FAN_COUNT | NUMBER(8) | The number of fans
POWER_SUPPLY_COUNT | NUMBER(8) | The number of power supplies
SYSTEM_BIOS | VARCHAR2(100) | The system BIOS
OPERATINGSYSTEM | VARCHAR2(453) | A summary of the OS name, version, update level, address length, and distributor version
OS_NAME | VARCHAR2(128) | The OS name
OS_VENDOR_NAME | VARCHAR2(128) | The OS vendor name
OS_BASE_VERSION | VARCAR2(100) | The OS base version
OS_UPDATE_LEVEL | VARCHAR2(100) | The OS update level
OS_DISTRIBUTOR_VERSION | VARCHAR2(100) | The OS distributor version
MAX_SWAP_SPACE_IN_MB | NUMBER | The maximum amount of swap space
OS_ADDRESS_LENGTH_IN_BITS | VARCHAR2(20) | The OS address length in bits
MAX_PROCESS_VIRTUAL_MEMORY | NUMBER | The maximum amount of virtual memory that can be allocated to a process
TIMEZONE | VARCHAR2(64) | The time zone as reported in the registry
TIMEZONE_REGION | VARCHAR2(64) | The time zone region as reported by the JVM
TIMEZONE_DELTA | NUMBER | The offset in minutes from GMT
NUMBER_OF_OS_PROPERTIES | NUMBER | The number of OS properties found
NUMBER_OF_OS_PATCHES | NUMBER | The number of OS patches found
NUMBER_OF_OS_FILESYSTEMS | NUMBER | The number of filesystems found
NUMBER_OF_OS_REGISTERED_SW | NUMBER | The number of OS-registered software products found
SNAPSHOT_ID | RAW(16) | The GUID of this configuration
TARGET_ID | RAW(16) | The GUID of the collector target
INTERNAL_TARGET_NAME | VARCHAR2(264) | The internal name of the client configuration
INTERNAL_TARGET_TYPE | VARCHAR2(64) | oracle_csa_client
COLLECTION_DURATION | NUMBER(16) | The amount of time it took to run CSA
LOADED_TIMESTAMP | DATE | The time at which the data was loaded into the repository
APPLET_VERSION | VARCHAR2(20) | The version of the applet
TARGET_ID_METHOD | VARCHAR2(100) | not used
CUSTOM_CLASS | VARCHAR2(1000) | The name of the custom class (if any)
CUSTOM_CLASS_VERSION | VARCHAR2(1000) | not used
KEY1 | VARCHAR2(4000) | Custom key 1(optional)
KEY2 | VARCHAR2(4000) | Custom key 2 (optional)
KEY3 | VARCHAR2(4000) | Custom key 3 (optional)
PROXY_TARGET_NAME | VARCHAR2(256) | The name of the collector target
PROXY_TARGET_DISPLAY_NAME | VARCHAR2(256) | The display name of the collector target
PROXY_TARGET_ID | RAW(16) | The GUID of the collector target
RULES_COUNT | NUMBER | The total number of rules evaluated (including rules with status of NA)
RULES_NA_COUNT | NUMBER | The number of rules that were not applicable
RULES_PASSED_COUNT | NUMBER | The number of rules that passed
RULES_INFO_COUNT | NUMBER | The number of rules that failed with status info
RULES_WARNING_COUNT | NUMBER | The number of rules that failed with status warning
RULES_CRITICAL_COUNT | NUMBER | The number of rules that failed with status critical

### MGMT$CSA_FAILED

MGMT$CSA_FAILED displays all failed collections.

Table 6-123 MGMT$CSA_FAILED

Column | Datatype | Description
--- | --- | ---
ID | RAW(16) | The GUID of this failed collection
TIMESTAMP | DATE | The time at which this failed collection occurred
TIMEZONE_DELTA | NUMBER | The offset in minutes from GMT
SAVED_TIMESTAMP | DATE | The time at which the data was loaded in the repository
EFFECTIVE_IP | VARCHAR2(20) | The effective IP address of the client
APPID | VARCHAR2(128) | The collection tag
REFERRING_URL_HEADER | VARCHAR2(4000) | The URL from which the user was referred to CSA, minus the query string
REFERRING_URL_PARAMS | VARCHAR2(4000) | The query string of the URL from which the user was referred to CSA
CSA_URL_HEADER | VARCHAR2(4000) | The URL from which the user ran CSA, minus the query string
CSA_URL_PARAMS | VARCHAR2(4000) | The query string of the URL from which the user tried to run CSA
DESTINATION_URL_HEADER | VARCHAR2(4000) | The destination URL minus the query string
DESTINATION_URL_PARAMS | VARCHAR2(4000) | The query string of the destination URL
BROWSER_TYPE | VARCHAR2(100) | The type of browser used to run CSA
BROWSER_VERSION | VARCHAR2(20) | The version of the browser used to run CSA
BROWSER_JVM_VENDOR | VARCHAR(100) | The vendor of the JVM used to run CSA
BROWSER_JVM_VERSION | VARCHAR2(20) | The version of the JVM used to run CSA
OS_ARCH | VARCHAR2(100) | The OS architecture of the client as reported in the ìos.archî Java system property
OS_NAME | VARCHAR2(100) | The OS name of the client as reported in the ìos.nameî Java system property
HTTP_REQUEST_USER_AGENT | VARCHAR2(100) | The HTTP user-agent header sent by the client
ERROR_CODE | VARCHAR2(1) | The error condition that caused the failed collection (0=OS not supported, 1=browser not supported, 2=applet certificate refused by user, 3=other error)
ERROR_TEXT | VARCHAR2(1024) | Text that is collected along with the error code, such as a stack trace

### MGMT$CSA_HOST_OS_COMPONENTS

MGMT$CSA_HOST_OS_COMPONENTS displays all OS components find on CSA client machines.

Table 6-124 MGMT$CSA_HOST_OS_COMPONENTS

Column | Datatype | Description
--- | --- | ---
DISPLAY_TARGET_NAME | VARCHAR2(256) | The display name of the client
TYPE | VARCHAR2(100) | The type of the component
NAME | VARCHAR2(128) | The name of the component
VERSION | VARCHAR2(100) | The version of the component
DESCRIPTION | VARCHAR2(2000) | The description of the component
ISNTALLATION_DATE | DATE | The date the component was installed
SNAPSHOT_ID | RAW(16) | The snapshot ID of the client configuration
TARGET_ID | RAW(16) | The target GUID of the collector target
COLLECTION_TIMESTAMP | DATE | The time at which the client configuration was collected

### MGMT$CSA_HOST_SW

MGMT$CSA_HOST_SW displays all OS-registered software found on CSA hosts.

Table 6-125 MGMT$CSA_HOST_SW

Column | Datatype | Description
--- | --- | ---
DISPLAY_TARGET_NAME | VARCHAR2(256) | The display name of the client
NAME | VARCHAR2(128) | The name of the software
VENDOR_NAME | VARCHAR2(128) | The name of the software vendor
VERSION | VARCHAR2(100) | The version of the software
INSTALLATION_DATE | DATE | The date on which the software as installed
INSTALLED_LOCATION | VARCHAR2(1024) | The location in which the software is installed
DESCRIPTION | VARCHAR2(2000) | The description of the software
VENDOR_SW_SPECIFIC_INFO | VARCHAR2(4000) | Any additional information provided by the vendor
SNAPSHOT_ID | RAW(16) | The snapshot ID of the client configuration
TARGET_ID | RAW(16) | The ID of the collector target
COLLECTION_TIMESTAMP | DATE | The time at which the data was collected

### MGMT$CSA_HOST_COOKIES

MGMT$CSA_HOST_COOKIES displays the cookies collected with client configurations.

Table 6-126 MGMT$CSA_HOST_COOKIES

Column | Datatype | Description
--- | --- | ---
DISPLAY_TARGET_NAME | VARCHAR2(256) | The display name of the client
NAME | VARCHAR2(4000) | The name of the cookie
VALUE | VARCHAR2(4000) | The payload of the cookie
SNAPSHOT_ID | RAW(16) | The snapshot ID of the client configuration
TARGET_ID | RAW(16) | The ID of the collector target
COLLECTION_TIMESTAMP | DATE | The time at which the data was collected

### MGMT$CSA_HOST_CUSTOM

MGMT$CSA_HOST_CUSTOM displays the custom properties collected with client configurations.

Table 6-127 MGMT$CSA_HOST_CUSTOM

Column | Datatype | Description
--- | --- | ---
DISPLAY_TARGET_NAME | VARCHAR2(256) | The display name of the client
TYPE | VARCHAR2(512) | The category of the custom property
NAME | VARCHAR2(512) | The name of the custom property
TYPE_UI | VARCHAR2(4000) | The display category of the custom property
NAME_UI | VARCHAR2(4000) | The display name of the custom property
VALUE | VARCHAR2(4000) | The value of the custom property
DISPLAY_UI | VARCHAR2(1) | Should this property be displayed in the UI? Y or N
HISTORY_TRACKING | VARCHAR2(1) | Not used
SNAPSHOT_ID | RAW(16) | The snapshot ID of the client configuration
TARGET_ID | RAW(16) | The ID of the collector target
COLLECTION_TIMESTAMP | DATE | The time at which the data was collected

### MGMT$CSA_HOST_RULES

MGMT$CSA_HOST_RULES displays the rules that were evaluated with each client configuration.

Table 6-128 MGMT$CSA_HOST_RULES

Column | Datatype | Description
--- | --- | ---
SNAPSHOT_ID | RAW(16) | The snapshot ID of the client configuration
NAME | VARCHAR2(128) | The name of the rule
DESCRIPTION | VARCHAR2(256) | The description of the rule
STATUS | NUMBER | The status of the rule (-2=NA, 15=passed, 18=info, 20=warning, 25=critical)
MOREINFO | VARCHAR2(1024) | Any additional information for the rule

### MGMT$CSA_HOST_CPUS

MGMT$CSA_HOST_CPUS displays information about the CPUs of CSA hosts. CSA assumes that in a multi-CPU host, all CPUs are identical.

Table 6-129 MGMT$CSA_HOST_CPUS

Column | Datatype | Description
--- | --- | ---
DISPLAY_TARGET_NAME | VARCHAR2(256) | The display name of the client
VENDOR_NAME | VARCHAR2(128) | The name of the CPU vendor
FREQ_IN_MHZ | NUMBER | The clock frequency of the CPU
ECACHE_IN_MB | NUMBER | The size of the extended cache
IMPL | VARCAHR2(500) | The CPU implementation
REVISION | VARCHAR2(2000) | The CPU revision
MASK | VARCHAR2(500) | The CPU mask
NUMBER_OF_CPUS | NUMBER | The number of CPUs
SNAPSHOT_ID | RAW(16) | The snapshot ID of the client configuration
TARGET_ID | RAW(16) | The ID of the collector target
COLLECTION_TIMESTAMP | DATE | The time at which the data was collected

### MGMT$CSA_HOST_IOCARDS

MGMT$CSA_HOST_IOCARDS displays all IO cards collected from client configurations.

Table 6-130 MGMT$CSA_HOST_IOCARDS

Column | Datatype | Description
--- | --- | ---
DISPLAY_TARGET_NAME | VARCHAR2(256) | The display name of the client
VENDOR_NAME | VARCHAR2(128) | The name of the IO card vendor
NAME | VARCHAR2(128) | The name of the IO card
FREQ_IN_MHZ | NUMBER | The frequency of the IO card bus
BUS | VARCHAR2(500) | The bus type (PCI or AGP)
REVISION | VARCHAR2(2000) | The IO card revision
NUMBER_OF_IOCARDS | NUMBER | The number of cards
SNAPSHOT_ID | RAW(16) | The snapshot ID of the client configuration
TARGET_ID | RAW(16) | The ID of the collector target
COLLECTION_TIMESTAMP | DATE | The time at which the data was collected

### MGMT$CSA_HOST_NICS

MGMT$CSA_HOST_NICS displays all network interface cards collected from client configurations.

Table 6-131 MGMT$CSA_HOST_NICS

Column | Datatype | Description
--- | --- | ---
DISPLAY_TARGET_NAME | VARCHAR2(256) | The display name of the client
NAME | VARCHAR2(128) | The name of the NIC
DESCRIPTION | VARCHAR2(500) | The description of the NIC
FLAGS | VARCHAR2(1024) | Flags set on the NIC – not applicable for Windows
MAX_TRANSFER_UNIT | NUMBER | The maximum transfer unit of the NIC
INET_ADDRESS | VARCHAR2(20) | The IP address of the NIC
MASK | VARCHAR2(20) | The subnet mask of the NIC
BROADCAST_ADDRESS | VARCHAR2(20) | The broadcast address of the NIC
MAC_ADDRESS | VARCHAR2(20) | The MAC address of the NIC
HOSTNAME_ALIASES | VARCHAR2(4000) | Any aliases for the hostname that are stored in the NIC
DEFAULT_GATEWAY | VARCHAR2(20) | The default gateway for the NIC
DHCP_ENABLED | VARCHAR2(1) | Whether or not DHCP is enabled
SNAPSHOT_ID | RAW(16) | The snapshot ID of the client configuration
TARGET_ID | RAW(16) | The ID of the collector target
COLLECTION_TIMESTAMP | DATE | The time at which the data was collected

### MGMT$CSA_HOST_OS_PROPERTIES

MGMT$CSA_HOST_OS_PROPERTIES displays all OS properties, such as environment variables, found on CSA hosts.

Table 6-132 MGMT$CSA_HOST_OS_PROPERTIES

Column | Datatype | Description
--- | --- | ---
DISPLAY_TARGET_NAME | VARCHAR2(256) | The display name of the client
SOURCE | VARHCAR2(128) | The source (e.g. the system environment) of the property
NAME | VARCHAR2(128) | The name of the property
VALUE | VARCHAR2(2000) | The value of the property
SNAPSHOT_ID | RAW(16) | The snapshot ID of the client configuration
TARGET_ID | RAW(16) | The ID of the collector target
COLLECTION_TIMESTAMP | DATE | The time at which the data was collected

### MGMT$CSA_HOST_OS_FILESYSEMS

MGMT$CSA_HOST_OS_FILESYSEMS displays all filesystems found on CSA hosts.

Table 6-133 MGMT$CSA_HOST_OS_FILESYSEMS

Column | Datatype | Description
--- | --- | ---
DISPLAY_TARGET_NAME | VARCHAR2(256) | The display name of the client
RESOURCE_NAME | VARCHAR2(128) | The name of the filesystem
MOUNT_LOCATION | VARCHAR2(1024) | The location from which it is mounted
TYPE | VARCHAR2(100) | The filesystem type
DISK_SPACE_IN_GB | NUMBER | The total disk space
AVAIL_DISK_SPACE_IN_GB | NUMBER | The available disk space
LOCAL_DRIVE | VARCHAR2(1) | The Windows drive letter on which it is mounted
MOUNT_OPTIONS | VARCHAR2(1024) | The mount options
SNAPSHOT_ID | RAW(16) | The snapshot ID of the client configuration
TARGET_ID | RAW(16) | The ID of the collector target
COLLECTION_TIMESTAMP | DATE | The time at which the data was collected

### MGMT$ECM_CONFIG_HISTORY

MGMT$ECM_CONFIG_HISTORY displays the data needed for generic categories.

Table 6-134 MGMT$ECM_CONFIG_HISTORY

Column | Datatype | Description
--- | --- | ---
DELTATIME | DATE | The time at which the diff was recorded
DELTAGUID | RAW(16) | The unique ID of the diff
TIMEZONE | VARCHAR2(64) | The time zone of the target
TARGET_NAME | VARCHAR2(256) | The name of the target
HOSTNAME | VARCHAR2(256) | The name of the target's host
TARGET_TYPE | VARCHAR2(64) | The type of the target
SNAPSHOTTYPE | VARCHAR2(64) | The type of the snapshot in which the diff was recorded
COLLECTIONTYPE | VARCHAR2(64) | The name of the table in which the diff occurred
TABLE_PATH | VARCHAR2(1000) | The full path of the table
CATEGORY | VARCHAR2(1132) | The fully qualified leaf category
OPERATION | VARCHAR2(10) | The type of change (update, delete, insert, same)
ROWGUID | RAW(16) | The entry ID GUID
ATTRIBUTE | VARCHAR2(64) | Attribute column name
NEWVALUE | VARCHAR2(4000) | New value of attribute
OLDVALUE | VARCHAR2(4000) | Old value of attribute

### MGMT$ECM_CONFIG_HISTORY_KEY1

MGMT$ECM_CONFIG_HISTORY_KEY1 displays the data needed for specific categories.

Table 6-135 MGMT$ECM_CONFIG_HISTORY_KEY1

Column | Datatype | Description
--- | --- | ---
DELTATIME | DATE | The time at which the diff was recorded
DELTAGUID | RAW(16) | The unique ID of the diff
TIMEZONE | VARCHAR2(64) | The time zone of the target
TARGET_NAME | VARCHAR2(256) | The name of the target
HOSTNAME | VARCHAR2(256) | The name of the target's host
TARGET_TYPE | VARCHAR2(64) | The type of the target
SNAPSHOTTYPE | VARCHAR2(64) | The type of the snapshot in which the diff was recorded
COLLECTIONTYPE | VARCHAR2(64) | The name of the table in which the diff occurred
TABLE_PATH | VARCHAR2(1000) | The full path of the table
CATEGORY | VARCHAR2(1132) | The fully qualified leaf category
OPERATION | VARCHAR2(10) | The type of change (update, delete, insert, same)
KEY1 | VARCHAR2(4000) | Value of Key 1
ATTRIBUTE | VARCHAR2(64) | Attribute column name
NEWVALUE | VARCHAR2(4000) | New value of attribute
OLDVALUE | VARCHAR2(4000) | Old value of attribute

### MGMT$ECM_CONFIG_HISTORY_KEY2

MGMT$ECM_CONFIG_HISTORY_KEY2 displays the data needed for specific categories.

Table 6-136 MGMT$ECM_CONFIG_HISTORY_KEY2

Column | Datatype | Description
--- | --- | ---
DELTATIME | DATE | The time at which the diff was recorded
DELTAGUID | RAW(16) | The unique ID of the diff
TIMEZONE | VARCHAR2(64) | The time zone of the target
TARGET_NAME | VARCHAR2(256) | The name of the target
HOSTNAME | VARCHAR2(256) | The name of the target's host
TARGET_TYPE | VARCHAR2(64) | The type of the target
SNAPSHOTTYPE | VARCHAR2(64) | The type of the snapshot in which the diff was recorded
COLLECTIONTYPE | VARCHAR2(64) | The name of the table in which the diff occurred
TABLE_PATH | VARCHAR2(1000) | The full path of the table
CATEGORY | VARCHAR2(1132) | The fully qualified leaf category
OPERATION | VARCHAR2(10) | The type of change (update, delete, insert, same)
KEY1 | VARCHAR2(4000) | Value of Key 1
KEY2 | VARCHAR2(4000) | Value of Key 2
ATTRIBUTE | VARCHAR2(64) | Attribute column name
NEWVALUE | VARCHAR2(4000) | New value of attribute
OLDVALUE | VARCHAR2(4000) | Old value of attribute

### MGMT$ECM_CONFIG_HISTORY_KEY3

MGMT$ECM_CONFIG_HISTORY_KEY3 displays the data needed for specific categories.

Table 6-137 MGMT$ECM_CONFIG_HISTORY_KEY3

Column | Datatype | Description
--- | --- | ---
DELTATIME | DATE | The time at which the diff was recorded
DELTAGUID | RAW(16) | The unique ID of the diff
TIMEZONE | VARCHAR2(64) | The time zone of the target
TARGET_NAME | VARCHAR2(256) | The name of the target
HOSTNAME | VARCHAR2(256) | The name of the target's host
TARGET_TYPE | VARCHAR2(64) | The type of the target
SNAPSHOTTYPE | VARCHAR2(64) | The type of the snapshot in which the diff was recorded
COLLECTIONTYPE | VARCHAR2(64) | The name of the table in which the diff occurred
TABLE_PATH | VARCHAR2(1000) | The full path of the table
CATEGORY | VARCHAR2(1132) | The fully qualified leaf category
OPERATION | VARCHAR2(10) | The type of change (update, delete, insert, same)
KEY1 | VARCHAR2(4000) | Value of Key 1
KEY2 | VARCHAR2(4000) | Value of Key 2
KEY3 | VARCHAR2(4000) | Value of Key 3
ATTRIBUTE | VARCHAR2(64) | Attribute column name
NEWVALUE | VARCHAR2(4000) | New value of attribute
OLDVALUE | VARCHAR2(4000) | Old value of attribute

### MGMT$ECM_CONFIG_HISTORY_KEY4

MGMT$ECM_CONFIG_HISTORY_KEY4 displays the data needed for specific categories.

Table 6-138 MGMT$ECM_CONFIG_HISTORY_KEY4

Column | Datatype | Description
--- | --- | ---
DELTATIME | DATE | The time at which the diff was recorded
DELTAGUID | RAW(16) | The unique ID of the diff
TIMEZONE | VARCHAR2(64) | The time zone of the target
TARGET_NAME | VARCHAR2(256) | The name of the target
HOSTNAME | VARCHAR2(256) | The name of the target's host
TARGET_TYPE | VARCHAR2(64) | The type of the target
SNAPSHOTTYPE | VARCHAR2(64) | The type of the snapshot in which the diff was recorded
COLLECTIONTYPE | VARCHAR2(64) | The name of the table in which the diff occurred
TABLE_PATH | VARCHAR2(1000) | The full path of the table
CATEGORY | VARCHAR2(1132) | The fully qualified leaf category
OPERATION | VARCHAR2(10) | The type of change (update, delete, insert, same)
KEY1 | VARCHAR2(4000) | Value of Key 1
KEY2 | VARCHAR2(4000) | Value of Key 2
KEY3 | VARCHAR2(4000) | Value of Key 3
KEY4 | VARCHAR2(4000) | Value of Key 4
ATTRIBUTE | VARCHAR2(64) | Attribute column name
NEWVALUE | VARCHAR2(4000) | New value of attribute
OLDVALUE | VARCHAR2(4000) | Old value of attribute

### MGMT$ECM_CONFIG_HISTORY_KEY5

MGMT$ECM_CONFIG_HISTORY_KEY5 displays the data needed for specific categories.

Table 6-139 MGMT$ECM_CONFIG_HISTORY_KEY5

Column | Datatype | Description
--- | --- | ---
DELTATIME | DATE | The time at which the diff was recorded
DELTAGUID | RAW(16) | The unique ID of the diff
TIMEZONE | VARCHAR2(64) | The time zone of the target
TARGET_NAME | VARCHAR2(256) | The name of the target
HOSTNAME | VARCHAR2(256) | The name of the target's host
TARGET_TYPE | VARCHAR2(64) | The type of the target
SNAPSHOTTYPE | VARCHAR2(64) | The type of the snapshot in which the diff was recorded
COLLECTIONTYPE | VARCHAR2(64) | The name of the table in which the diff occurred
TABLE_PATH | VARCHAR2(1000) | The full path of the table
CATEGORY | VARCHAR2(1132) | The fully qualified leaf category
OPERATION | VARCHAR2(10) | The type of change (update, delete, insert, same)
KEY1 | VARCHAR2(4000) | Value of Key 1
KEY2 | VARCHAR2(4000) | Value of Key 2
KEY3 | VARCHAR2(4000) | Value of Key 3
KEY4 | VARCHAR2(4000) | Value of Key 4
KEY5 | VARCHAR2(4000) | Value of Key 5
ATTRIBUTE | VARCHAR2(64) | Attribute column name
NEWVALUE | VARCHAR2(4000) | New value of attribute
OLDVALUE | VARCHAR2(4000) | Old value of attribute

### MGMT$ECM_CONFIG_HISTORY_KEY6

MGMT$ECM_CONFIG_HISTORY_KEY6 displays the data needed for specific categories.

Table 6-140 MGMT$ECM_CONFIG_HISTORY_KEY6

Column | Datatype | Description
--- | --- | ---
DELTATIME | DATE | The time at which the diff was recorded
DELTAGUID | RAW(16) | The unique ID of the diff
TIMEZONE | VARCHAR2(64) | The time zone of the target
TARGET_NAME | VARCHAR2(256) | The name of the target
HOSTNAME | VARCHAR2(256) | The name of the target's host
TARGET_TYPE | VARCHAR2(64) | The type of the target
SNAPSHOTTYPE | VARCHAR2(64) | The type of the snapshot in which the diff was recorded
COLLECTIONTYPE | VARCHAR2(64) | The name of the table in which the diff occurred
TABLE_PATH | VARCHAR2(1000) | The full path of the table
CATEGORY | VARCHAR2(1132) | The fully qualified leaf category
OPERATION | VARCHAR2(10) | The type of change (update, delete, insert, same)
KEY1 | VARCHAR2(4000) | Value of Key 1
KEY2 | VARCHAR2(4000) | Value of Key 2
KEY3 | VARCHAR2(4000) | Value of Key 3
KEY4 | VARCHAR2(4000) | Value of Key 4
KEY5 | VARCHAR2(4000) | Value of Key 5
KEY6 | VARCHAR2(4000) | Value of Key 6
ATTRIBUTE | VARCHAR2(64) | Attribute column name
NEWVALUE | VARCHAR2(4000) | New value of attribute
OLDVALUE | VARCHAR2(4000) | Old value of attribute

### MGMT$HW_NIC

MGMT$HW_NIC displays performance information for host hardware network cards.

Table 6-141 MGMT$HW_NIC

Column | Datatype | Description
--- | --- | ---
HOST_NAME | VARCHAR2(256) | The host name
NAME | VARCHAR2(128) | The name of the card
INET_ADDRESS | VARCHAR2(20) | The IP address of the card
MAX_TRANSFER_UNIT | NUMBER | The maximum transfer unit
BROADCAST_ADDRESS | VARCHAR2(20 | The broadcast address of the card
MASK | VARCHAR2(20) | The card's subnet mask
FLAGS | VARCHAR2(1024) | The flags on the card
MAC_ADDRESS | VARCHAR2(20) | The MAC address of the card
HOST_ALIASES | VARCHAR2(4000) | The aliases for the hostname
SNAPSHOT_GUID | RAW(16) | The GUID of the config. snapshot

### MGMT$OS_COMPONENTS

MGMT$OS_COMPONENTS displays performance information for host OS components.

Table 6-142 MGMT$OS_COMPONENTS

Column | Datatype | Description
--- | --- | ---
HOST | VARCHAR2(256) | The name of the host
NAME | VARCHAR2(128) | The name of the component
TYPE | VARCHAR2(100) | The type of the component
VERSION | VARCHAR2(100) | The version of the component
DESCRIPTION | VARCHAR2(2000) | The description of the component
INSTALLATION_DATE | DATE | The installation date of the component
SNAPSHOT_GUID | RAW(16) | The GUID of the config. snapshot

### MGMT$OS_FS_MOUNT

MGMT$OS_FS_MOUNT displays performance information for mounted filesystems.

Table 6-143 MGMT$OS_FS_MOUNT

Column | Datatype | Description
--- | --- | ---
HOST_NAME | VARCHAR2(256) | The host name
RESOURCE_NAME | VARCHAR2(128) | The name of the mounted resource
TYPE | VARCHAR2(100) | The filesystem type
MOUNT_LOCATION | VARCHAR2(1024) | The mount location
MOUNT_OPTIONS | VARCHAR2(1024) | The mount options
SNAPSHOT_GUID | RAW(16) | The GUID of the config. snapshot

### MGMT$OS_HW_SUMMARY

MGMT$OS_HW_SUMMARY displays summary information for both operating systems and hardware.

Table 6-144 MGMT$OS_HW_SUMMARY

Column | Datatype | Description
--- | --- | ---
HOST_NAME | VARCHAR2(256) | The host name
DOMAIN | VARCHAR2(500) | The host's domain
OS_SUMMARY | VARCHAR2(352) | A summary of OS information
SYSTEM_CONFIG | VARCHAR2(4000) | The system configuration
MA | VARCHAR2(500) | The machine architecture
FREQ | NUMBER | The CPU frequency
MEM | NUMBER | The total amount of memory
DISK | NUMBER | The total amount of disk space
CPU_COUNT | NUMBER | The number of CPUs
VENDOR_NAME | VARCHAR2(128) | The name of the system vendor
OS_VENDOR | VARCHAR2(128) | The name of the OS vendor
DISTRIBUTOR_VERSION | VARCHAR2(100) | The OS distributor version
SNAPSHOT_GUID | RAW(16) | The GUID of the config. snapshot

### MGMT$OS_KERNEL_PARAMS

MGMT$OS_KERNEL_PARAMS displays performance information for OS kernel parameters.

Table 6-145 MGMT$OS_KERNEL_PARAMS

Column | Datatype | Description
--- | --- | ---
HOST | VARCHAR2(256) | The name of the host
SOURCE | VARCHAR2(128) | The source of the parameter
NAME | VARCHAR2(128) | The name of the parameter
VALUE | VARCHAR2(2000) | The value of the parameter
DATATYPE | VARCHAR2(4000) | The data type of the parameter
SNAPSHOT_GUID | RAW(16) | The GUID of the config. snapshot

### MGMT$OS_PATCHES

MGMT$OS_PATCHES displays performance information for OS patches.

Table 6-146 MGMT$OS_PATCHES

Column | Datatype | Description
--- | --- | ---
HOST | VARCHAR2(256) | The name of the host
OS_EXTENDED | VARCHAR2(352) | A summary column that includes update level and address length
OS | VARCHAR2(229) | A summary column that includes name and version
PATCH | VARCHAR2(128) | The name of the patch

### MGMT$OS_SUMMARY

MGMT$OS_SUMMARY displays operating system summary information.

Table 6-147 MGMT$OS_SUMMARY

Column | Datatype | Description
--- | --- | ---
HOST | VARCHAR2(256) | The name of the host
NAME | VARCHAR2(128) | The name of the OS
VENDOR_NAME | VARCHAR2(128) | The name of the OS vendor
BASE_VERSION | VARCHAR2(100) | The base version of the OS
UPDATE_LEVEL | VARCHAR2(100) | The update level of the OS
DISTRIBUTOR_VERSION | VARCHAR2(100) | The distributor version of the OS
MAX_SWAP_SPACE_IN_MB | NUMBER | The maximum amount of swap space
SNAPSHOT_GUID | RAW(16) | The GUID of the config. snapshot

### MGMT$SOFTWARE_COMP_PATCHSET

MGMT$SOFTWARE_COMP_PATCHSET displays information on components and patchsets.

Table 6-148 MGMT$SOFTWARE_COMP_PATCHSET

Column | Datatype | Description
--- | --- | ---
HOST_NAME | VARCHAR2(256) | The name of the host
HOME_NAME | VARCHAR2(64) | The name of the Oracle Home
HOME_LOCATION | VARCHAR2(128) | The path of the Oracle Home
COMPONENT_NAME | VARCHAR2(128) | The name of the component
COMPONENT_BASE_VERSION | VARCHAR2(64) | The base version of the component
COMPONENT_VERSION | VARCHAR2(64) | The current version of the component
PATCHSET_NAME | VARCHAR2(128) | The name of the patchset
PATCHSET_VERSION | VARCHAR2(64) | The version of the patchset
SNAPSHOT_GUID | RAW(16) | The GUID of the config. snapshot

### MGMT$SOFTWARE_COMPONENT_ONEOFF

MGMT$SOFTWARE_COMPONENT_ONEOFF displays information on oneoff patches.

Table 6-149 MGMT$SOFTWARE_COMPONENT_ONEOFF

Column | Datatype | Description
--- | --- | ---
HOST_NAME | VARCHAR2(256) | The name of the host
HOME_NAME | VARCHAR2(64) | The name of the Oracle Home
HOME_LOCATION | VARCHAR2(128) | The path of the Oracle Home
COMPONENT_NAME | VARCHAR2(128) | The name of the component
COMPONENT_EXTERNAL_NAME | VARCHAR2(128) | The external name of the component
COMPONENT_BASE_VERSION | VARCHAR2(64) | The base version of the component
COMPONENT_VERSION | VARCHAR2(64) | The current version of the component
PATCH_ID | VARCHAR2(128) | The ID of the patch
SNAPSHOT_GUID | RAW(16) | The GUID of the config. snapshot

### MGMT$SOFTWARE_COMPONENTS

MGMT$SOFTWARE_COMPONENTS displays information on components.

Table 6-150 MGMT$SOFTWARE_COMPONENTS

Column | Datatype | Description
--- | --- | ---
NAME | VARCHAR2(128) | The name of the component
EXTERNAL_NAME | VARCHAR2(128) | The external name of the component
BASE_VERSION | VARCHAR2(64) | The base version of the component
PATCHSETS_IN_HOME | VARCHAR2(4000) | List of patchsets in home
VERSION | VARCHAR2(64) | The version of the component
HOST_NAME | VARCHAR2(256) | The name of the host
HOME_LOCATION | VARCHAR2(128) | The path of the Oracle Home
HOME_NAME | VARCHAR2(64) | The name of the Oracle Home
DESCRIPTION | VARCHAR2(1024) | A description of the component
INSTALLER_VERSION | VARCHAR2(64) | The version of the installer
MIN_DEINSTALLER_VERSION | VARCHAR2(64) | The minimum deinstaller version
INSTALL_TIMESTAMP | DATE | The installation date
IS_TOP_LEVEL | VARCHAR2(1) | Whether or not the component is a top-level component
INTERIM_PATCHES_IN_HOME | VARCHAR2(4000) | The interim patches in the home
BUGS_FIXED_BY_INTERM_INPATCEHS | VARCHAR2(4000) | A list of bugs fixed by the interim patches in the home
SNAPSHOT_GUID | RAW(16) | The GUID of the config. snapshot

### MGMT$SOFTWARE_DEPENDENCIES

MGMT$SOFTWARE_COMPONENTS displays information on components.

Table 6-151 MGMT$SOFTWARE_DEPENDENCIES

Column | Datatype | Description
--- | --- | ---
HOST_NAME | VARHCAR2(256) | The name of the host
REFERENCER_HOME_NAME | VARCHAR2(64) | The Oracle Home of the referencing component
REFERENCER_HOME_LOCATION | VARCHAR2(128) | The Oracle Home path of the referencing component
REFERENCER_NAME | VARCHAR2(128) | The name of the referencing component
REFERNCER_BASE_VERSION | VARCHAR2(64) | The base version of the referencing component
REFERENCED_HOME_NAME | VARCHAR2(64) | The Oracle Home of the referenced component
REFERENCED_HOME_LOCATION | VARCHAR2(128) | The Oracle Home path of the referenced component
REFERENCED_NAME | VARCHAR2(128) | The name of the referenced component
REFERENCED_BASE_VERSION | VARCHAR2(64) | The base version of the referenced component
SNAPSHOT_GUID | RAW(16) | The GUID of the configuration snapshot

### MGMT$SOFTWARE_HOMES

MGMT$SOFTWARE_HOMES displays information about Oracle Homes.

Table 6-152 MGMT$SOFTWARE_HOMES

Column | Datatype | Description
--- | --- | ---
HOST_NAME | VARHCAR2(256) | The name of the host
HOME_NAME | VARCHAR2(64) | The name of the Oracle Home
HOME_TYPE | VARCHAR2(11) | The type of the Oracle Home
HOME_LOCATION | VARCHAR2(128) | The path of the Oracle Home
SNAPSHOT_GUID | RAW(16) | The GUID of the config. snapshot

### MGMT$SOFTWARE_ONEOFF_PATCHES

MGMT$SOFTWARE_ONEOFF_PATCHES displays information on oneoff patches applied in Oracle Homes.

Table 6-153 MGMT$SOFTWARE_ONEOFF_PATCHES

Column | Datatype | Description
--- | --- | ---
HOST_NAME | VARHCAR2(256) | The name of the host
HOME_NAME | VARCHAR2(64) | The name of the Oracle Home
HOME_LOCATION | VARCHAR2(128) | The path of the Oracle Home
PATCH_ID | VARCHAR2(128) | The ID of the patch
INSTALL_TIMESTAMP | DATE | The installation date
DESCRIPTION | VARCHAR2(1024) | A description of the patch
IS_ROLLBACKABLE | VARCHAR2(1) | Whether or not the patch can be rolled back
SNAPSHOT_GUID | RAW(16) | The GUID of the configuration snapshot

### MGMT$SOFTWARE_OTHERS

MGMT$SOFTWARE_OTHERS displays information on other software installed on hosts.

Table 6-154 MGMT$SOFTWARE_OTHERS

Column | Datatype | Description
--- | --- | ---
HOST_NAME | VARHCAR2(256) | The name of the host
SOFTWARE_NAME | VARCHAR2(128) | The name of the software
SOFTWARE_VENDOR | VARCHAR2(128) | The software vendor
SOFTWARE_VERSION | VARCHAR2(128) | The software version
INSTALLATION_DATE | DATE | The software installation date
INSTALLATION_LOCATION | VARCHAR2(1024) | The software installation location
SNAPSHOT_GUID | RAW(16) | The GUID of the configurtion snapshot

### MGMT$SOFTWARE_PATCHES_IN_HOMES

MGMT$SOFTWARE_PATCHES_IN_HOMES displays information on software patches in Oracle Homes.

Table 6-155 MGMT$SOFTWARE_PATCHES_IN_HOMES

Column | Datatype | Description
--- | --- | ---
HOST_NAME | VARHCAR2(256) | The name of the host
HOME_NAME | VARCHAR2(64) | The name of the Oracle Home
HOME_LOCATION | VARCHAR2(128) | The path of the Oracle Home
PATCH_ID | VARCHAR2(128) | The ID of the patch
BUGS_FIXED | VARCHAR2(4000) | List of bugs fixed by the patch
SNAPSHOT_GUID | RAW(16) | The GUID of the config. snapshot

### MGMT$SOFTWARE_PATCHSETS

MGMT$SOFTWARE_PATCHSETS displays information on patchsets installed in Oracle Homes.

Table 6-156 MGMT$SOFTWARE_PATCHSETS

Column | Datatype | Description
--- | --- | ---
HOST_NAME | VARHCAR2(256) | The name of the host
HOME_NAME | VARCHAR2(64) | The name of the Oracle Home
HOME_LOCATION | VARCHAR2(128) | The path of the Oracle Home
NAME | VARCHAR2(128) | The name of the patchset
VERSION | VARCHAR2(64) | The version of the patchset
DESCRIPTION | VARCHAR2(1024) | A description of the patchset
INSTALLER_VERSION | VARCHAR2(64) | The version of the installer
MIN_DEINSTALLER_VERSION | VARCHAR2(64) | The minimum deinstaller version
INSTALL_TIMESTAMP | DATE | The time at which the patchset was installed
SNAPSHOT_GUID | RAW(16) | The GUID of the config. snapshot

## Database Cluster Views

### MGMT$CLUSTER_INTERCONNECTS

MGMT$CLUSTER_INTERCONNECTS displays statistics of network interfaces on the hosts in clusters.

Table 6-157 MGMT$CLUSTER_INTERCONNECTS

Column | Datatype | Description
--- | --- | ---
CLUSTER_NAME | VARCHAR2(256) | Cluster target name
HOST_NAME | VARCHAR2(256) | Host target status
IF_NAME | VARCHAR2(256) | Interface name
IF_SUBNET | VARCHAR2(16) | Subnet of the interface
IF_PUBLIC | VARCHAR2(10) | Whether the interface is public (YES) or private(NO)
TOTRATE_5MIN | NUMBER | The average total transfer rate (MB/sec) on the interface in the past 5 minutes
TOTERR_5MIN | NUMBER | The percentage of error packets on the interface in the past 5 minutes
INRATE_5MIN | NUMBER | The average input rate (MB/sec) on the interface in the past 5 minutes
CURR_WARNING | NUMBER | The number of warning alerts on the interface
CURR_CRITICAL | NUMBER | The number of critial alerts on the interface.
LATEST_COLLECTION_TIMESTAMP | DATE | The time when the data is collected.

### MGMT$RACDB_INTERCONNECTS

MGMT$RACDB_INTERCONNECTS displays statistics of the inter-instance traffic of cluster databases.

Table 6-158 MGMT$RACDB_INTERCONNECTS

Column | Datatype | Description
--- | --- | ---
CLUSTER_NAME | VARCHAR2(1024) | Cluster target name
DB_TARGET | VARCHAR2(256) | Cluster database target name
INSTANCE_TARGET | NUMBER | Cluster database instance target name.
INSTANCE_STATUS | NUMBER | Cluster database instance status
DB_NAME | VARCHAR2(1024) | Database name
SID | VARCHAR2(1024) | Instance name
IF_NAME | VARCHAR2(50) | The network interface the instance is using for inter-instance communication
HOST_NAME | VARCHAR2(256) | Host target name on which the instance is running
IF_IP | VARCHAR2(16) | The ip address of the network interface
IF_PUBLIC | VARCHAR2(10) | Whether the interface is public (YES) or private (NO)
IF_SOURCE | VARCHAR2(100) | Where does the instance pick up the interface
XFERRATE_5MIN | NUMBER | The trasfer rate of the instance to other instances
CURR_WARNING | NUMBER | The number of warning alerts of the instance regarding inter_instance communication
CURR_CRITICAL | NUMBER | The number of critical alerts of the instance regarding inter_instance communication
LATEST_COLLECTION_TIMESTAMP | DATE | The time the data is collected

### MGMT$HA_BACKUP

MGMT$HA_BACKUP displays details of the latest backup of the databases.

Table 6-159 MGMT$HA_BACKUP

Column | Datatype | Description
--- | --- | ---
HOST | VARCHAR2(256) | Host the database is on
DATABASE_NAME | VARCHAR2(256) | Database target name
TARGET_TYPE | VARCHAR2(64) | Target type of the database. (cluster_database or oracle_database)
DISPLAY_NAME | VARCHAR2(256) | Display name of the target
TARGET_GUID | RAW(16) | The target GUID
SESSION_KEY | NUMBER | Session identifier
SESSION_RECID | NUMBER | Together, with SESSION_STAMP, used to uniquely identify job output from V$RMAN_OUTPUT
SESSION_STAMP | NUMBER | Together, with SESSION_RECID, used to uniquely identify job output from V$RMAN_OUTPUT
COMMAND_ID | VARCHAR2(33) | Either a user-specified SET COMMAND ID or a unique command ID generated by RMAN
STATUS | VARCHAR2(23) | One of the following values: ² RUNNING WITH WARNINGS ² RUNNING WITH ERRORS ² COMPLETED ² COMPLETED WITH WARNINGS ² COMPLETED WITH ERRORS ² FAILED
START_TIME | DATE | Start time of the first BACKUP command in the job
END_TIME | DATE | End time of the last BACKUP command in the job
TIME_TAKEN_DISPLAY | VARCHAR2(4000) | Time taken, shown in user-displayable format <nn>h:<nn>m:<nn>s
INPUT_TYPE | VARCHAR2(13) | Contains one of the following values. If the user command does not satisfy one of them, then preference is given in order, from top to bottom of the list. ² DB FULL ² RECVR AREA ² DB INCR ² DATAFILE FULL ² DATAFILE INCR ² ARCHIVELOG ² CONTROLFILE ² SPFILE
OUTPUT_DEVICE_TYPE | VARCHAR2(17) | Can be DISK, SBT, or *. An * indicates more than one device (in most cases, it will be DISK or SBT).
INPUT_BYTES_DISPLAY | VARCHAR2(4000) | Values in user-displayable form. They will be converted to a format of nM, nG, nT, nP, and so on.
OUTPUT_BYTES_DISPLAY | VARCHAR2(4000) | Values in user-displayable form. They will be converted to a format of nM, nG, nT, nP, and so on
OUTPUT_BYTES_PER_SEC_DISPLAY | VARCHAR2(4000) | Output write-rate-per-second. These values are in user-displayable form. They will be converted to a format of nM, nG, nT, nP, and so on.

## Storage Reporting Views

### MGMT$STORAGE_REPORT_DATA

MGMT$STORAGE_REPORT_DATA displays the Storage Data metric attributes which are common across all instrumented Storage Entities.

Table 6-160 MGMT$STORAGE_REPORT_DATA

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(256) | Target Name in Enterprise Manager
TARGET_TYPE | VARCHAR2(64) | Target Type in Enterprise Manager
KEY_VALUE | RAW(20) | Unique Key Value for the Storage Entity
GLOBAL_UNIQUE_ID | RAW(20) | A globally unique persistent identifier for a storage entity. All instances of a shared Storage Entity will have the same global_unique_identifier
NAME | VARCHAR2(256) | Name of the Storage Entity
STORAGE_LAYER | VARCHAR2(32) | Storage layer of the Storage Entity. Example: - OS_DISK - VOLUME_MANAGER - LOCAL_FILESYSTEM - NFS
ENTITY_TYPE | VARCHAR2(64) | Indicates the type of Entity. Value is vendor specific. Example: Plex, Sub Disk, Diskgroup, Volume group, Metadevice etc.
RAWSIZEB | NUMBER | Total space in bytes
SIZEB | NUMBER | Size in bytes
USEDB | NUMBER | Used size in bytes
FREEB | NUMBER | Free size in bytes

### MGMT$STORAGE_REPORT_KEYS

MGMT$STORAGE_REPORT_KEYS displays the relationship between instrumented Storage Entities.

Table 6-161 MGMT$STORAGE_REPORT_KEYS

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(256) | Target Name in Enterprise Manager
TARGET_TYPE | VARCHAR2(64) | Target Type in Enterprise Manager
KEY_VALUE | RAW(20) | Unique KEY_VALUE for the Storage Entity
PARENT_KEY_VALUE | RAW(20) | Key value for the parent Storage Entity.

### MGMT$STORAGE_REPORT_PATHS

MGMT$STORAGE_REPORT_PATHS displays the OS paths for all instrumented storage Entities.

Table 6-162 MGMT$STORAGE_REPORT_PATHS

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(256) | Target Name in Enterprise Manager
TARGET_TYPE | VARCHAR2(64) | Target Type in Enterprise Manager
KEY_VALUE | RAW(20) | Unique Key Value for the Storage Entity
NAME | VARCHAR2(256) | Name of the Storage Entity
PATH | VARCHAR2(256) | OS path to the Storage Entity
FILE_TYPE | VARCHAR2(256) | Type of file Examples: - _BLOCKSPECIAL - _DIRECTORY - _REGULAR
STORAGE_LAYER | VARCHAR2(32) | Storage layer of the Storage Entity. Examples: - OS_DISK - VOLUME_MANAGER - LOCAL_FILESYSTEM - NFS
ENTITY_TYPE | VARCHAR2(64) | Indicates the type of Entity. Value is vendor specific. Examples: Plex, Sub Disk, Diskgroup, Volume group, Metadevice etc.

### MGMT$STORAGE_REPORT_ISSUES

MGMT$STORAGE_REPORT_ISSUES displays the consistency issues encountered when analyzing the instrumented storage metrics.

Table 6-163 MGMT$STORAGE_REPORT_ISSUES

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(256) | Target Name in Enterprise Manager
TARGET_TYPE | VARCHAR2(64) | Target Type in Enterprise Manager
TYPE | VARCHAR2(32) | Type of inconsistency. Value can be one of - MAPPING_ISSUE - MAPPING_WARNING
MESSAGE_COUNT | NUMBER | Count of the number of messages

### MGMT$STORAGE_REPORT_DISK

MGMT$STORAGE_REPORT_DISK displays Additional Storage Data Metric Attributes for all Physical Disk Device Storage Entities.

Table 6-164 MGMT$STORAGE_REPORT_DISK

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(256) | Target Name in Enterprise Manager
TARGET_TYPE | VARCHAR2(64) | Target Type in Enterprise Manager
ENTITY_TYPE | VARCHAR2(64) | Indicates the type of Disk Device such as Disk or Disk Partition
USED_PATH | VARCHAR2(256) | The OS path to the disk or partition. If the disk or partition is allocated, then this is the path that is in use.
FILE_TYPE | VARCHAR2(256) | Type of file Examples:- _BLOCKSPECIAL- _REGULAR
SIZEB | NUMBER | Size in bytes
USEDB | NUMBER | Used size in bytes
FREEB | NUMBER | Free size in bytes
VENDOR | VARCHAR2(256) | Name of the disk vendor; detected through SCSI enquiry
PRODUCT | VARCHAR2(256) | Product family from the vendor; detected through SCSI enquiry

### MGMT$STORAGE_REPORT_VOLUME

MGMT$STORAGE_REPORT_VOLUME displays Additional Storage Data Metric attributes for all Volume Manager Storage Entities.

Table 6-165 MGMT$STORAGE_REPORT_VOLUME

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(256) | Target Name in Enterprise Manager
TARGET_TYPE | VARCHAR2(64) | Target Type in Enterprise Manager
VENDOR | VARCHAR2(256) | Vendor name of the Volume or Software Raid Manager
PRODUCT | VARCHAR2(256) | Vendor name of the Volume or Software Raid Manager
TYPE | VARCHAR2(64) | ndicates the type of Volume entity. It can be vendor specific. In the case of Veritas Volume Manager for e.g. Volume, Plex, VM Disk, Diskgroup, Sub Disk, Metadevice, Metadevice Partition, Array, Raiddevice, Submirror, Diskset, Slice, raid-disk, spare-disk, Hot spare etc.
DISK_GROUP | VARCHAR2(256) | Disk group or Volume group name
NAME | VARCHAR2(256) | The name of the entity in the volume manager namespace
USED_PATH | VARCHAR2(256) | The OS path to the device. If the device is allocated, then this is the path that is in use.
FILE_TYPE | VARCHAR2(256) | Type of file Examples:- _BLOCKSPECIAL- _REGULAR
RAWSIZEB | NUMBER | In bytes. For a 2-way mirrored Veritas Volume. It is the sum of the size of each plex.
SIZEB | NUMBER | Size in bytes
USEDB | NUMBER | Used size in bytes
FREEB | NUMBER | Free size in bytes
CONFIGURATION | VARCHAR2(256) | A string describing the configuration of the Volume.

### MGMT$STORAGE_REPORT_LOCALFS

MGMT$STORAGE_REPORT_LOCALFS displays Additional Storage Data Metric attributes for all Local Filesystem Storage Entities.

Table 6-166 MGMT$STORAGE_REPORT_LOCALFS

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(256) | Target Name in Enterprise Manager
TARGET_TYPE | VARCHAR2(64) | Target Type in Enterprise Manager
FILESYSTEM_TYPE | VARCHAR2(256) | The type of filesystem
FILESYSTEM | VARCHAR2(256) | The filesystem path on the operating system
MOUNTPOINT | VARCHAR2(256) | The mountpoint path on the operating system
SIZEB | NUMBER | NUMBER
USEDB | NUMBER | Used size in bytes
FREEB | NUMBER | Free size in bytes

### MGMT$STORAGE_REPORT_NFS

MGMT$STORAGE_REPORT_NFS displays Additional Storage Data Metric attributes for all Network Filesystems.

Table 6-167 MGMT$STORAGE_REPORT_NFS

Column | Datatype | Description
--- | --- | ---
TARGET_NAME | VARCHAR2(256) | Target Name in Enterprise Manager
TARGET_TYPE | VARCHAR2(64) | Target Type in Enterprise Manager
FILESYSTEM | VARCHAR2(256) | The filesystem name as seen on the operating system. For NFS filesystems the filesystem name should be in the format nfs_server:/filesystem_name
MOUNTPOINT | VARCHAR2(256) | The mountpoint path on the operating system
SIZEB | NUMBER | Size in bytes
USEDB | NUMBER | Used size in bytes,
FREEB | NUMBER | Free size in bytes
NFS_SERVER | VARCHAR2(256) | The server name for the NFS Server.
NFS_SERVER_IP_ADDRESS | VARCHAR2(256) | The IP address of the NFS Server
NFS_VENDOR | VARCHAR2(256) | The NFS Server vendor
MOUNT_PRIVILEGE | VARCHAR2(256) | {READ|WRITE} This is the mount privilege of the filesystem.